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 0
Combo or list box 0
Synchronize combo boxes 2
Validation Rules for a Control on a Form (?) 4
Combo Box Not in List function 1
Clearing data in a Form 4
Clearing a multivalued combo box 9
Combo Box 5

Top