Access 2016 Intermediate

Access 2016

Lesson 1 – Setting Field Properties

By default, a lookup field allows the user to add data values to the lookup list by typing them into the field. Limit data entry to just those values on the lookup list by selecting Yes in the Limit to List box; the default value of No allows free entry.



Procedures

1. Open the desired table in Design view. 2. Select the lookup field you want to modify. 3. Select the Lookup tab in the Field Properties pane. 4. Select the property you want to modify. 5. Modify the property as desired.



Step-by-Step

Modify Lookup properties.

If necessary, open the Orders table in Design view.

Steps

Practice Data

1. Select the lookup field you want to modify. The field is selected. 2. Select the Lookup tab in the Field Properties pane. The Lookup page appears. 3. Select the property you want to modify. The insertion point appears in the corresponding property box.

Click in the Shipping Method field, if necessary

Click the Lookup tab, if necessary

Click in the Column Widths box

4. Modify the property as desired.

Follow the instructions below to complete this step

The Lookup properties are modified accordingly.

Change the text in the Column Widths property to 0";1" . Then, change the Limit To List property to Yes .

OFFICEPRO, Inc.

Page 31