check for empty text field

K

kathy

What is the correct syntax to check for an empty text
field?

I've tried

If Status_of_Activity = " " Then
If Status_of_Activity = blank Then
If Status_of_Activity = empty Then
If Status_of_Activity = Null Then

Thank you!
 
M

Max Smart

If Trim([Status_of_Activity]) & "" = "" Then

That will catch both null values and empty string values.

Max
 

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

Shared Link is showing empty notebook 1
I have lost 6 months work, how can i get my file back 1
How to remove preloaded-text upon creation of a new Word file? 0
Footer text appears "squished" 1
Using Access Database to build contracts with fields on pdf document 0
Matching literal text "???" in Word 2010 field code IF statement 2
Word OLE to check spelling in text box 1
Set Querydef SQL to Null (Open an empty query editor) 21

Top