Access: Control position problems

Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.

Q:  Jane writes that when she makes a new form by clicking the Form button in the Create tab of the Ribbon, all the controls are the same width, and she can’t resize them individually, as in older versions of Access.

A:  This is a “feature” of recent versions of Access.  It is called Layout, and here is how you can turn it off:  First, select the group by clicking the little four-headed arrow in the upper left corner (make sure you see orange outlines around all the controls), then right-click, select the Layout item, and then Remove Layout from its context menu:

AW 1701-H

The Layout feature is occasionally useful – for example, to create a quick data entry form for heads-down data entry – but mostly not, so I generally turn it off as soon as I create a new form using the Form button (or I just select the Form Design button instead, which lets me position controls individually).

Want More?

Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.