Not allowing an empty combo box

  • Thread starter Thread starter Greg
  • Start date Start date
Greg said:
How do I set a combo box to not accept a blank answer?

Greg

well, there are a couple ways, depending on what you are doing. if the
combo box is bound to a table column you can set the column to require a
value. this will prevent saving the record unless the field is filled. you
can write code for the combo box itself to check for a value, but that will
only work if you actually get into the box then leave it so you can detect
an update or activate event. or you can write code on the form to check for
a valid value before you save the record or close the form, i like this one
the best as it gives you explicit control so you can put up a nice message
box.. and it works even if the combo box isn't bound to a column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cascading Combo Boxes - How to deal with one being empty? 5
Combo box problem 1
"Reset" combo boxes 4
Combo box help 1
Combo Box Selection is Blank 1
Combo box in a Form 3
my combo boxes 2
combobox rowsource 3

Back
Top