[AccessD] vbNull = 1

Gustav Brock gustav at cactus.dk
Wed Jan 21 12:00:42 CST 2004


Hi Mark and Charlotte

Thanks!
I had forgotten vbNull is related to VarType() ... that explains.

Then I guess this guy is slightly off track abusing our constants but
he managed to confuse me:

  http://www.imt.net/~joe/matt/program/vb/HOWTOs/ShellExecuteAPI/

/gustav


> Gustav,

> There is a very short discussion of "When is Nothing something?" here:
> http://www.vbdesign.net/expresso/archive/topic/3244.html

> Mark

> vbNull

> This one is great for testing for Null in a variable (database users take
> note) using VarType:

> If VarType (varVariable) = vbNull Then

> again, don't use this constant to try to assign a Null value, because its
> not nothing..
> True value of vbNull is 1 (in a string variable "1")
> ************

> Why does the VB constant vbNull equal 1 and not 0 (zero)?



More information about the AccessD mailing list