Limit combo box to list or Null

B

bh

How would I set a validation rule to effectively "limit to list" a combo box
field, but also allow nulls? Thanks in advance.
 
A

Allen Browne

bh said:
How would I set a validation rule to effectively "limit to list" a combo
box field, but also allow nulls? Thanks in advance.
Click to expand...

No action needed. That's the default behavior for Access.

LimitToList does not block nulls. (Make sure you are using null, not a
zero-length string.)
 

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

Combo Box - Limit to List 17
NotInList 1
Combo Box default value 1
Limit to List - Combo Box 1
Limit to list and default for combobox 2
Limit to List 1
Using Combo Box selections to automatically populate fields 2
NotInList 3

Top