What is the opposite of IsNull ?

  • Thread starter Thread starter Stu
  • Start date Start date
S

Stu

I'm trying to express a condition where a text field is
not blank. There's no such thig as IsNotNull, what do I
use? I tried >1 but I get a calc error because its a text
field.
 
I'm trying to express a condition where a text field is
not blank. There's no such thig as IsNotNull, what do I
use? I tried >1 but I get a calc error because its a text
field.
Click to expand...

You can go a couple of ways:

Not IsNull([FieldName])
or
[FieldName] Is Not Null
 
-----Original Message-----
I'm trying to express a condition where a text field is
not blank. There's no such thig as IsNotNull, what do I
use? I tried >1 but I get a calc error because its a text
field.
.
Use Is Not Null
Click to expand...
 
In my code, for ease of reading, I use:

if IsNull(me!Company) = True then
--- company is null

or, in your case

if IsNull(me!Company) = False then
 
Back
Top