using NOT in a condition

J

justin_vasko

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?
 
K

Ken Snell [MVP]

Len(txtfield & "") > 0

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

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