Show All

Hide All

1. Open a form, report, or data access page (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.) in Design view (Design view: A window that shows the design of these database objects: tables, queries, forms, reports, macros, and data access pages. In Design view, you can create new database objects and modify the design of existing ones.).
2. Display the field list (field list: A window that lists all the fields in the underlying record source or database object, except in data access page Design view. In data access page Design view, it lists all the record sources and their fields in the underlying database.) by clicking Field List on the toolbar.
3. To select the field or fields that will serve as the basis for the control (control: A graphical user interface object, such as a text box, check box, scroll bar, or command button, that lets users control the program. You use controls to display data or choices, perform an action, or make the user interface easier to read.), 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 (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form, report, or data access page.) (data access page only)	Click the Wizards tool in the toolbox (toolbox: A set of tools that is available in Design view to add controls to a form, report, or data access page. The toolset available in page Design view is different from the toolset available in form and report Design view.) if it's not already selected (selected: A toolbar button always has a border around it when it's selected, even when the pointer is not resting on the button.), 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.