Create drop-down choice menu for access table columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top