using NOT in a condition

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

Guest

i am trying to make a condition for whether a text field is blank, or not...

i have it working for if it is blank txtfield=""

but i am trying to make it so it is not equal to "" or blank...

any tips on making a "not" type of condition?
 
Len(txtfield & "") > 0

Above is true when the txtfield contains a string or value.

Or, if txtfield cannot be Null, you can use
txtfield <> ""
 
Back
Top