Access 2003 Intermediate

SECTION 2

Modifying a Lookup Field

Now that you know how to establish a lookup field, you can modify certain characteristics of the field to suit your database’s needs. If you open the Northwind database, open the Order Details table in Design view, and click the ProductID field, you can view the lookup field properties by clicking the Lookup tab at the bottom of the window:

The following properties are available to adjust:

Display Control	You can choose between a Text Box, List Box, or Combo box for the lookup field.
Row Source Type	You can specify between Table/Query, Value List, or Field List.
Row Source	The query or data that the lookup field uses.
Bound Column	Lists how many columns that currently constitute the lookup field.
Column Count	Number of columns that are available to use as a lookup field.
Column Heads	Can specify Yes/No if a field label, caption, or first row of data used to construct the lookup field values will be used.
Column Widths	Lists the dimensions of the columns used in the lookup field. The number of columns in the Column Count field is the same number of dimensions listed here.
List Rows	Maximum number of rows that are displayed if combo box is the specified Display Control.
List Width	Width of the combo box if specified as Display Control.
Limit to List	Forces user to use only the values in the lookup field; that is they cannot enter any data not specified by the query.