how do you make a drop down list in Access field?

[timv]

setting up fields and would like drop down lists rather than typing in same
information constantly

 

[Al Campagna]

Tim,
See Help under "Combo boxes"
Combo boxes allow the user to select a value, from a list of values...
provided by a table, a query, or a manually entered value list.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Jeff Boyce]

You posted in a newsgroup devoted to supporting Microsoft Access tables and
db design.

If you question concerns doing this ("drop down lists") directly in tables,
DON'T! Although Access offers "lookup" data type in more recent versions,
you (and those who need to maintain the app after you) will find it is "high
maintenance".

The preferred approach is to use the appropriate data type for the primary
key of the looked-up table (?long int?), then use FORMS to hold comboboxes
(drop-downs). Do the looking up, by all means, but do it in forms, not in
tables.

Access tables store data, Access form display it.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

setting up fields and would like drop down lists rather than typing in same
information constantly

Use a Form - NOT a table datasheet!!! - to enter your data, and put a Combo
Box control on the form.