Validation Rule

[George]

In my table for one of my items I am using a Validation Rule that looks like
this:

Like "?????" What I need is to add: Is Not Null to that statement. What
should it look like ?

Thanks

 

[Jeff Boyce]

George

Like "?????" and Is Not Null

(untested ... you might need to use the IsNull function...)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[George]

Thanks - That works..

George

Like "?????" and Is Not Null

(untested ... you might need to use the IsNull function...)

Regards

Jeff Boyce
Microsoft Office/Access MVP