Home
ABOUT
Books
Tips
Links & Downloads

 

 

 

Forms/Reports

Locking a Tool

Selecting Multiple Fields

Sizing a Label

Selecting Controls in a Row

Locking a Tool  (Access 97 and later)

When you select a tool other than the Select Objects tool, that tool becomes

deselected after you use it to place a control on your form. If you plan to create

several controls using the same tool—for example, a series of check boxes

in an option group—double-click the control button in the toolbox to "lock" it.

You can unlock it by clicking any other tool button (including the Select Objects tool).

Top

Selecting Multiple Fields  (All Versions)

A quick way to place several successive fields on a form or report is to click the first

field you want in the field list, scroll down until you see the last field you want, and

then hold down the Shift key while you click the last field. This procedure selects

all the fields between the first and last fields you selected. You can also

double-click the title bar of the field list to select all the fields in the field list.

Holding down the Ctrl key and clicking several noncontiguous fields works

too. Click any of the highlighted fields and drag the fields as a group to the

Detail section of the form or report.

Top

Sizing a Label  (All Versions)

To quickly adjust the size of a label, select the label, choose the Size command

from the Format menu, and then choose To Fit from the submenu.  You can also

double-click any of the sizing handles to perform a size to fit.

Top

Selecting Controls in a Row  (All Versions)

To select all controls in a vertical area, click the horizontal ruler above

the area containing the controls you want to select. Likewise, to select all

controls in a horizontal area, click the vertical ruler.

Top