Access: Control position problems

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

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 225x300 - Access: Control position problems

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).

subs profile e1563205311409 - Access: Control position problems
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address