How to evaluate x="" with nz or isnull or isempty functions?

[Guest]

Hi there.

I have x.value=""

Why does this hapen?
IsNull(x) -- returns false
IsEmpty(x) -- returns false

I have to evaluate the x.value and return 0 (zero) if the value doesn't
contain any value. How can I get arround with this?

thanks

 

[Allen Browne]

These are all different:
- zero-length string (string containing no characters),
- Null (a field without a value),
- Empty (an initialized Variant),
- Nothing (an initialized object),
- Missing (an unsupplied optional argument.)

For more info, see:
Nulls: Do I need them?
at:
http://allenbrowne.com/casu-11.html

 

[JethroUK©]

try:

=NZ(x,0)

 

[Guest]

I tried "If nz(x,0) = 0 then" but it returns False.

 

[Rick Brandt]

I tried "If nz(x,0) = 0 then" but it returns False.

You have stated that x = "". "" is not the same as Null which is what Nz()
works on.

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George