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.

Editor's Picks