How to hard code two values for a column?

  • Thread starter Thread starter LAS
  • Start date Start date
L

LAS

I want a column to have only to possible values. I don't want to make a
whole table so I can use a normal combo box as a "lookup." Can I somehow
hard code two values for a dropdown on that column?

tia
las
 
Thanks! Exactly what I was looking for!

Allen Browne said:
In table design view, you can select the field and (in the lower pane) set
the Display Control to Combo.

Set the Row Source Type to Value List
Then type the valid values into the RowSource, e.g.:
"M"; "F"
Set Limit To List to Yes so it accepts only these values.
Click to expand...
 
Back
Top