using NOT in a condition

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

 

[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 <> ""