Software

Save time with Access' automatic control spacing feature

The wizard may not know all—especially when it comes to spacing. Access' automatic control spacing feature easily adjusts the horizontal or vertical distance between controls. Learn more in this tip.

When you create an Access form with a wizard, the controls might be set too close together. Likewise, as you add or move form controls, they may not be spaced equally from one another. While you could move each one individually until it looks right, you can save time by having Access adjust the spacing for you. Follow these steps:

  1. Open the form in Design View and press [Ctrl]A.
  2. Go to Format | Vertical Spacing and select Equal.

Now, all the controls will be equally spaced vertically from one another. If you would like Access to further increase the spacing between the controls, follow these steps:

  1. Open the form in Design View and press [Ctrl]A.
  2. Go to Format | Vertical Spacing and select Increase as often as needed. (Selecting Decrease will decrease the distance between them.)

You can also use the Automatic Control Spacing feature to adjust the horizontal distance between the controls.

Once you have increased the distance between the controls, you may find that when you run the form, the contents of the form no longer fit within the form window. To fit the contents to the windows, follow these steps:

  1. Open the form in Design View and drag the form boundaries to fit the form's contents.
  2. Run the form. If the window is maximized, click the Restore button.
  3. Go to Windows | Size to Fit Form.
  4. Click Save.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox