Display data from a field in a table or a query

1. Open a form in Design view, a report in Design view, or a data access page in Design view.
   
   
2. If you want to use a wizard to help you create the control, make sure that the Control Wizards tool in the toolbox is pressed in.

   Notes

   • On forms and reports, you can use wizards to create command buttons, list boxes, subforms, combo boxes, and option groups. On data access pages, you can use wizards to create command buttons, list boxes, and drop-down list boxes.
     
     
   • Wizards are not available in a stand-alone data access page, or when you point a data access page to a database other than the one currently open. In this case, you will have to create the control without using a wizard.
3. Display the field list by clicking Field List on the toolbar.
   
   
4. Do one of the following:
   • Select one or more fields in the field list on a form or report.

   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	Double-click the field list title bar.

   
   
   • Select a field, table, or query in the field list on a data access page.

   To select	Do this
   One field	Click the field.
   A table or query	Click the Wizards tool in the toolbox if it's not already pressed in, and click the table or query.

   
   

5. Do one of the following:
   • Drag the field(s) from the field list and position them on the form or report.
     
     
   • Drag the field, table, or query from the field list and position it on the data access page. In the Layout Wizard dialog box, click Individual Controls.
     
     
   • Note   You must drag the field(s), table, or query from the field list. If you click the field(s), table, or query in the field list and then click the form, report, or data access page, Microsoft Access won't create the control. 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, 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. Each text box also has an attached label by default.
6. 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.

Notes

• Access creates the appropriate control for the field and sets certain properties, based on the field's data type. If this isn't the type of control that you want to create, click the appropriate control tool in the toolbox before dragging the field from the field list. In a form or report, controls are also created based on the settings of the DisplayControl property. To read about the DisplayControl property, click .
  
  
• In forms and reports, you can also change a control to another type of control after you create it.

How?