Set properties for a query, its fields, or its field lists

You can set properties for queries, field lists in a query, and fields you add to the design grid in a query.

1. Open a query in Design view.
   
   
2. Select a field, field list, or query.
   • To select a field, click the cell in the Field row.
     
     
   • To select a field list, click anywhere in the list.
     
     
   • To select the whole query, click anywhere in query Design view outside the design grid and the field lists.
3. Click Properties on the toolbar to display the property sheet for the selected object.
   
   
4. In the property sheet, click the property you want to set, and then do one of the following:
   • If an arrow appears in the property box, click the arrow and then click a value from the list.
     
     
   • Type a setting or expression in the property box.
     
     
   • If the Build button appears next to the property box, click it to display a builder.

     If you need more space to enter or edit a property setting, press SHIFT+F2 to open the Zoom box.

Tip   To get more information on a property and its settings, click the property in the property sheet, and then press F1.