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.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays