Differentiating between CDbl(0) and Nothing

[TCopple]

I have a conditional that takes a double variable. Basically I need the conditional to run if the variable is the value of 0.0, but not if it's nothing.

Unfortunately it seems as though the type Double, treats a value of Nothing as 0.0

Anyone know a way around this? Is there a wrapper double object like in Java?

Thanks,
Tyler

 

[SkipVought]

NOTHING is a state for an OBJECT.

Condsider define as a Variant.

"When variables are initialized, a numeric variable is initialized to 0, a variable-length string is initialized to a zero-length string (""), and a fixed-length string is filled with zeros. Variant variables are initialized to Empty. Each element of a user-defined type variable is initialized as if it were a separate variable."

Skip,
[sub]
[red][/red]
[/sub]