Software

How to space controls evenly across an Access form

Access offers a handy command that makes it easy to give your forms a more polished look. See how equally spacing controls can improve the effect.
For a professional look, Access form controls should not only be aligned by their borders, but the spacing between them should also be the same. For example, say you want to distribute the vertical space evenly between the controls shown in Figure A. Follow these steps:

Figure A

  1. Press Ctrl + A to select all the controls on the form.
  2. Go to Format | Vertical Spacing and then click Make Equal. (In Access 2007, click the Make Vertical Spacing Equal command in the Position group of the Forms Design Tools Arrange tab (Figure B).

Figure B

  1. Click Increase Vertical Spacing as many times as necessary (Figure C).

Figure C

To distribute controls horizontally, as shown in Figure D, click Horizontal Spacing in step 2. In Access 2007, click the Make Horizontal Spacing Equal command.

Figure D


Miss an Access tip?

Check out the Microsoft Access archive and catch up on other 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
cshrand
cshrand

Possibly because on my form, objects are on a tab, following  these directions doesn't work. There is no choice for "Vertical Spacing" on the Format tab; On the Arrange tab, then "Sizing & Ordering," you can choose "Size/Space". However, clicking on "Equal Horizontal" under Spacing, aligns two of the three chosen objects to the far right side of the current tab.

Editor's Picks