Category Archives: Forms / Reports

Forms / Reports

Selecting Multiple Fields (All Versions)

      Comments Off on 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… Read more »

Sizing a Label (All Versions)

      Comments Off on 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.

Selecting Controls in a Row (All Versions)

      Comments Off on 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.

Locking a Tool (Access 97 and later)

      Comments Off on 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… Read more »