Combo Box: Need to prevent null entry.

[culcuhain]

Good morning,
I have a combo box in Access on a form. I need the user to select from the list, however; the list shows a null/blank until the user selects the drop down arrow. Currently the user can just hit enter and move to the next field without selecting anything. I cannot have this happen.
For the Field/Combo Box I have
Limit to List: Yes
Allow Value List Edits: No

What am I missing?
Thanks!

 

[Montez659]

There are several different options.

One is simply to make the default value of the box the first item in the combobox, that way something is always selected and it will never return a null.

Secondly, you could try to set the "on lose focus" event property to validate the text that is in the box. This would probably require some VBA coding though not too hard, although I always seem to have a problem resetting the focus back on the combobox.