Conditions in Macro

  • Thread starter Thread starter Suze
  • Start date Start date
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 !!
 
Try:
Not (IsNull([SomeField])

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