How to hard code two values for a column?

[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

 

[Allen Browne]

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.

 

[LAS]

Thanks! Exactly what I was looking for!

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.