What is the opposite of IsNull ?

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

 

[Allen Browne]

In a query, use:
Is Not Null

In VBA code, use:
Not IsNull(MyField)

 

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

You can go a couple of ways:

Not IsNull([FieldName])
or
[FieldName] Is Not Null

 

[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

 

[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