Conditions in Macro

S

Suze

What is the opposite of IsNull. I want to set up a macro
that will activate if a field DOES have data in it, as
opposed to being empty, but just don't know the correct
expression to use. HELP !!
 
A

Allen Browne

Try:
Not (IsNull([SomeField])

In the context of a query, you can use:
[SomeField] Is Not Null
 
Top