Access Combo Box - force the user to enter a value
Posted on 2009-07-07
I have a form with a combo box, I want to force the user to enter a value into this Field
Combo Box(or a drop down menu) called "Currency" has a list choice of "GBP" or "Eur"
I have the default value set to "Select Currency"
I have the properties "Limit to List" option set to "yes" So the field should only save with values of "GBP" or "EUR"
If you tab past the combo box, Access save the record with the default value ("Select Currency"), however the validation does work if you click on the field and type something other than the values in the list.
How can I get Access to look at the combo box even if the user tabs over this field and tries to save the record?
Thanks for your help.