Forms / Reports

Selecting Multiple Fields (All Versions)

Posted April 26, 2011 By Mike

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 non-contiguous 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.

Sizing a Label (All Versions)

Posted April 26, 2011 By Mike

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.

Selecting Controls in a Row (All Versions)

Posted April 26, 2011 By Mike

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.

Locking a Tool (Access 97 and later)

Posted April 22, 2011 By Mike

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).