Access: Now Playing (Page 1) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

Table Tools -> Design -> View->-> Design View Create a List Box Sometimes, you need to select more than one value from a list. In Access 2007, you can create a MultiValue field. This is a Text field that can look up the data in a small, static list. It can also lookup the values in another table.   Try it: Create A Value List Select the City field. It is a Text box. Select the Lookup tab. Edit the Display Control: List Box     Type the Row Source: Adamsville, Commerce Township, My Town   Allow Multiple Values: Yes Save and test the changes to your table.