Comparing Null

[bengalliboy]

OK I guess I am not thinking .... Can any one help me on this?
I am setting a value at some point of my program as 'Null'
(X =null)
Now when I am comparing the Null it does not return 'True'
(If X is Null or Y is Null then
'Do this
else: msgbox "X or Y is not valid"
Exit
End If
)

Waht am I missing here? Thanks

 

[pfan]

I don't know what type of variable you are using for x, but instead of setting it to Null, try setting x = "".

This has worked well in my applications, but again I don't know what you are using x for.

 

[SkipVought]

Hi,
take a look at Help - Variant Data Type Skip,
metzgsk@voughtaircraft.com