Limit to list in Combobox: it doesn't

X

XP

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
 
J

jsrogol

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.
 
B

Bill Edwards

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