Access 2016 Intermediate

Lesson 1 – Setting Field Properties

Access 2016

Col1

Col2

1

UPS

2

DHL

3

FedEx

4

US Mail

5

Emery

Return to the table and continue on to the next step (step 10).

Save the table and switch to Datasheet view. Select the Shipping Method field for the first record; then, select 1 UPS from the lookup list. Press [Down] , type 1 into the Shipping Method field of the second record, and press [Down] again. For the third record, type 2 and press [Down] . For the fourth record, type 3 and press [Enter] .

Switch back to Design view.

M ODIFYING L OOKUP P ROPERTIES



Discussion

You can use the Lookup page in the Field Properties pane to modify the properties of a lookup list.

If the lookup list was manually typed, you can use the Row Source property to edit it or add to it. Column values are separated by semi-colons ( ; ) and text entries are enclosed in quotation marks ( " ).

The Bound Column property indicates which lookup column is used to store field values. For instance, if the lookup list consists of two columns, and column 1 is the bound column, the data in column 1 will be stored in the lookup field.

Although you may want the values in the bound column to be stored in the field, they may be confusing and uninformative to the user; the descriptive text in an unbound field may have more meaning. You can suppress the display of the bound column and display only the descriptive text in the unbound column of a lookup list by changing the width of the bound column to zero ( 0” ) in the Column Width box.

Page 30

OFFICEPRO, Inc.