empty text field

R

rml

I have a button on a form which I would like to check if a text field is
empty or null. I used [field1] = null but this does not work. Is this
correct?

Thanks.
 
R

Rick B

You can't have something "equal to null"

Try...

[field1] is null

or Isnull([field1])
 
Top