isnull/notnull??

[spinkung]

Mornin all,

I'm tring to write an if statement that is the oppsosite of ...

If IsNull(RS![Unit Type])

can someone tell me what the not null version of the is because i've tried

if NotNull(...) and i've tried if Not Null(...) but neither seem to work.

Yes i'm a noob.

cheers,
spinkung.

 

[allan57]

If IsNull(RS![Unit Type])=False Then

 

[unclejoe]

hi,

Try.

if Not IsNull((RS![Unit Type]) then

Mornin all,

I'm tring to write an if statement that is the oppsosite of ...

If IsNull(RS![Unit Type])

can someone tell me what the not null version of the is because i've tried

if NotNull(...) and i've tried if Not Null(...) but neither seem to work.

Yes i'm a noob.

cheers,
spinkung.

 

[spinkung]

thanks both, thats crakced it.

If IsNull(RS![Unit Type])=False Then

cheers,
spinkung.

 

[WayneRyan]

If Not IsNull(RS![Unit Type]) Then

Wayne