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.

1 comments
Jablonski
Jablonski

Microsoft, in their 'infinite wisdom', have not seen fit to provide Toolbar buttons for these options in any version up to 2003 - don't know about 2007. However, I create my own by opening any Form or Report in design view, then selecting Tools/Customize, then opening the Format menu, clicking Vertical Spacing, holding down a Control Key and dragging the Make Equal button onto a toolbar (custom or otherwise). Each button needs to be setup one at a time.

Editor's Picks