Software

Save time by changing multiple Access form/report controls at once

When you want to apply the same format to more than one control, it's far more efficient to update them at the same time. Here's a look at how to do it.
If you need to make the same change to a number of controls, there no need to do it more than once. Access lets you update a property common to each of the selected controls simultaneously. For example, say you would like the label controls on this form shown in Figure A to stand out by changing their Fore and Back Colors.

Figure A

Order form

First, select the controls by clicking one control and then holding down [Shift] while selecting the other controls. (You can also select them by dragging the mouse to draw a rectangle around them.) After selecting the controls, follow these steps:

  1. Click the Properties tool in the Forms Design toolbar. (In Access 2007, click the Properties Sheet command in the in the Tools Group of the Forms Design Tools tab.
  2. Click the Builder Button in the Back Color property and select Black.
  3. Click the Builder Button in the Fore Color property and select White (Figure B).

Figure B

form design

When you run the form, all selected controls will display with a white font on a black background, as shown in Figure C.

Figure C

Formatted form


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.

0 comments

Editor's Picks