Table field drop-down menu

[Guest]

Hi anyone know how to put a drop down menu directly in a table field? I did
it once but can't remember how. Thanks much.

 

[Guest]

Set the Display Control property of the field to Combo Box on the Lookup tab
of the field's properties in table design view and set the other properties
appropriately to hide the bound column and show the value looked up (usually
from another table). I'd advise against it however. Data input should be
done via a form where you can use a combo box as the control bound to the
field to achieve the same result. Using a combo box in raw datasheet view
can be confusing as it hides the true value of the column.

Ken Sheridan
Stafford, England

 

[RoyVidar]

Hi anyone know how to put a drop down menu directly in a table field?
I did it once but can't remember how. Thanks much.

Please continue to not know how, as it will probably only lead to
problems. Some reasons why, can be found here
http://www.mvps.org/access/lookupfields.htm

Use combos on forms in stead ;-)

 

[Guest]

Thanks. Another question, how does "it [hide] the true value of the column"?
the one I have now shows a blank until the user chooses an option from the
menu, which then populates the box. Thanks again for your help, I really
appreciate it.