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

N

Nuno Guerra

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
 
A

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
 
E

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
 
E

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
 
Top