When you need to make the same change to a number of nonadjacent controls in Access, click one of them, and then hold [Shift] while you select the others. To select adjacent cells, click outside one control and then drag across the others to draw a rectangle around them. This will select all controls within the rectangle.
If you are making a change to all the controls on a report or form, you can select them all at once by pressing [Ctrl][A]. You can also use the ruler to select adjacent controls. Click anywhere on either the horizontal or vertical ruler to select all controls under or to the right of the clicked mark; or, you can just drag your mouse along the ruler to select everything below. If you find that you have selected a control that you do not wish to change, simply hold [Shift] and click to deselect it.
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.