Preventing combobox from showing no record.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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.
 
Back
Top