Allow blank within validation rule

[hilian]

In my text box, txt2_itp_1, allowable values are blank, 0, 1, 2, 98, or 99. When I use the following validation rule,

[txt2_itp_1]="" Or "0" Or "1" Or "2" Or "98" Or "99", Access doesn't allow the user to leave the field blank.

I tried [ISNULL] instead of "", and got the same result, an error message telling me to enter a valid number. I've found plenty of ways to require a field to be filled in, but none to allow a selection of values that includes null.

How do I do this?

[June7]

Is this a BOUND textbox? Is it bound to a number field?

[txt2_itp_1]=0 Or 1 Or 2 Or 98 Or 99 Or Is Null

[hilian]

It's bound to a numeric field called 2_itp_1.

[hilian]

I just tried your revised syntax, [txt2_itp_1]=0 Or 1 Or 2 Or 98 Or 99 Or Is Null, and it worked. Thanks much!!

I had tried IS Null at the beginning of the rule and it didn't work. do you know why it works at the end but not the beginning?

[June7]

No idea but I do remember having the same issue.

[hilian]

Oh Well. But at least there's one way it works. Thanks!