IsNull or Is Not Null... that is the question

[cranebill]

Ok i can have a statement like this:

If IsNull(Variable) Then do something

How can i determine if variable is not null?

Bill

 

[Tranman]

Bill,
You'll hate this....If Not IsNull(variable) then

It **IS** Monday.

Tranman

 

[TonyJollans]

Hi Bill,

When you're stuck, there's always the really simple, if ugly ..

If IsNull(Variable) Then
Else
    ' Do your stuff
EndIf

But what you're looking for (and if your Shakespeare had been slightly better would have found ) is ..

If Not IsNull(Variable) Then

Enjoy,
Tony

 

[cranebill]

Funny thing is i actually tried IsNotNull lol

Thanx

 

[cranebill]

Is there somewhere online where i can possibly find a list of commands like these?

 

[CajunCenturion]

It's not a matter of finding commands like If Not IsNull and If IsNull, but rather understanding what is going on. By consulting the documentation, you'll see that IsNull is a function, which returns a boolean value, that is True or False. The Not is a boolean operator (also described in the documentation), which toggles a boolean value.

So if the function IsNull returns True, then Not IsNull will perform a boolean operation (Not) against the function return, which in this case is Not True, or simply False.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein