Preventing combobox from showing no record.

[Guest]

How do I prevent users from blanking out the value in a combobox? I want
them to be able to chose ONLY from the records in the combobox and not to be
able select and delete an item in the list. Limit to List doesn't seem to
work.

appreciated

 

[Allen Browne]

Right: LimitToList doesn't force the user to make a choice.

If the combo is bound to a field, you could open the table in design view,
and set the field's Required property to Yes. Then Access won't let the user
delete from the list and leave the field blank.

 

[Guest]

Hi Allen - Thank you for responding. Actually, my comboboxes are unbound,
but I've found that using a validation rule of Is Not Null seems to be
working OK. I wasn't worried about deleting a record but just preventing the
combo from showing a blank.