Nulls in Modules

[Ron Carr]

Why can't I set a variable in vba to Null, when data in
recordsets is null, and I need to set the data or compare
it?
vba does not allow setting a variable to Null.
I suspect it is a setting somewhere but have not found it.
Thanks!

 

[Alex Dybenko]

if you have variable Variant type - you can assing it to null, else you cant
what variable type you have?

 

[Ron Carr]

These are String variables

-----Original Message-----
if you have variable Variant type - you can assing it to null, else you cant
what variable type you have?
--
Alex Dybenko (MVP)
http://Alex.Dybenko.com





.

 

[Alex Dybenko]

strings you cant assing null to. use variant instead

 

[Allen Browne]

Ron, for general guidance on handling the Null value (including assigning
and testing), see:
Common errors with Null
at:
http://users.bigpond.net.au/abrowne1/casu-12.html

 

[Ron Carr]

Got it: need to define as Variant to work with Nulls.
Thanks.