Text Mask

[quattda]

I am creating a table where I want to have a field where the data entry person is limited to 4 choices of two characters (e.g., AB, BC, CD, or EF). What would be the best strategy for doing this?

Thanks

 

[Kryst51]

How about a combo box that only has those choices in it? You could put the choices in a table with its own autonumber key, then you can reference the autonumber key in your main table. then use the combo box wizard to reference the choice table and store the result in the main table.

 

[quattda]

Thank you. I will give that a try. I have not worked with combo boxes before but am always pushing my knowledge of Access.

 

[Kryst51]

Check out the wizard and post back here if you have trouble. Good luck.