What is the opposite of IsNull ?

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.
 
F

fredg

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
 
G

Guest

-----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...
 
A

Albert D. Kallal

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
 
Top