Limit to list in Combobox: it doesn't

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

Guest

Using Office 2003 and Windows XP.

I have several combo boxes on a tab control on a form. I set "Limit to List"
to YES and the change takes; meaning I can later open the properties and see
that it is set to YES.

The combo's are filled with numbers from 0 - 250; I would expect therefore,
that a user would have to enter any number from 0 to 250; however, I can
blank the box, effectively set it to null and it accepts this, even when I
click into another field or switch tabs.

How can I correct this issue and REALLY limit to list?

Thanks much in advance.
However, it allows
 
Is the property of the field set to required in the table? Also you can set
the validation rule to require a value between two numbers if you are only
using numbers.
 
You could set the validation rule of the combo box to:

IS NOT NULL

Or you could check for len() < 1 or isnull in code in the after update
event.
 
You must log in or register to reply here.

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

Remove Limit to list when in filter 2
combobox null entry 3
Excute Limit to List programatically 1
Combo Box and Limit To List 4
Cbo box Limit to list = No write question 2
limit combo boxes 5
limit to list - save to table not working 5
Not In List question 1

Back
Top