Microsoft Office Tutorials and References
In Depth Information
Modifying Table Structure
7.
Click in the Row Source box, and click the
three dots on the right. The Edit List Items
dialog box appears.
Default Option
If you want Access to display one of the
choices automatically, click the arrow in
the Default Value box and select the choice
you want.
8. Enter the list you want for the field as seen
in Figure 19-19. You can enter as many items
as desired.
Allow
Allow
Click here to display
Multiple
Value
the Edit List Items
9. Click OK.
Values
List Edits
dialog box
10. Click the Save button to save your changes.
Datasheet View
To return to Datasheet View, choose
Home>Views>View (arrow)>Datasheet View.
Figure 19-19
Creating a lookup list.
Search JabSto ::




Custom Search