Create drop-down choice menu for access table columns

S

Steve Kelly

I'm creating a table for entering information. In several columns there are a
limited number of allowable choices. Can I create a drop-down menu for these
columns?

Any help will be appreciated; I'm a newbie at Access.
 
R

rowiga

You can use a combo box. The combo box will allow you to
query existing tables that could store your choices or you
can choose to "List" the values that you want to include
in your choices. It sounds like you want to do the latter
so you'd choose Value List in the properties box for the
combo box and then type in your choices in the Row Source
box below separated by semicolons...such as....

Red;Blue;Green;Mauve;Pink
 
Top