Not allowing an empty combo box

N

No One

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


Top