check for empty text field

  • Thread starter Thread starter kathy
  • Start date Start date
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!
 
If Trim([Status_of_Activity]) & "" = "" Then

That will catch both null values and empty string values.

Max
 
Back
Top