Show All

Add a field to a form, report, or data access page

1. Open a form, report, or data access page in Design view.
2. Display the field list by clicking Field List on the toolbar.
3. To select the field or fields that will serve as the basis for the control, do one of the following:

   To select	Do this
   One field	Click the field.
   A block of fields	Click the first field in the block, hold down the SHIFT key, and then click the last field in the block.
   Nonadjacent fields	Hold down the CTRL key and click the name of each field that you want to include.
   All fields (form or report only)	Double-click the field list title bar.
   A table or query (data access page only)	Click the Wizards tool in the toolbox if it's not already selected, and then click the table or query.

   Tip

   In a data access page, to quickly create one control that is based on a field, double-click that field in the field list.

4. Do one of the following:
   • Drag the field or fields from the field list to the form, report, or data access page.
   • Drag the table or query from the field list to the data access page. In the Layout Wizard dialog box, click the layout that you want to use.

   Note  You must drag the field or fields, the table, or the query from the field list. If you click the item in the field list and then click the form, report, or data access page, Microsoft Access won't create the control or controls. Access places one text box on the form, report, or data access page for each field that you select in the field list. If you select a table or query in the data access page field list and then select Columnar or Tabular in the Layout Wizard, Access places a text box for each field in the table or query on the data access page. Each text box is bound to one field in the underlying data source.

5. Place the upper-left corner of the icon where you want the upper-left corner of the main control (not its label) to be, and release the mouse button.

Note  Access creates the appropriate control for the field and sets certain properties, based on the field's data type. To specify the type of control you want to use, click the appropriate control tool in the toolbox before dragging the field from the field list.