Conditions in Macro

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

 

[Allen Browne]

Try:
Not (IsNull([SomeField])

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