empty text field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You can't have something "equal to null"

Try...

[field1] is null

or Isnull([field1])
 
You must log in or register to reply here.

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

Testing for null 4
WHERE clause for a NULL/Empty field 2
Change Null Value to Text 1
Search any field 10
Update Fields If FROM Table Fields Are NOT NULL 2
delete parent records where child fields are blank 2
Can't have a null value if another field has text. 5
#error - Blank 3

Back
Top