Null & Nz function

[loisk]

I am still not clear about the differences between Null & Nz.
Please excuse my idiot question, but can anybody give an explanation?
Thanks!

[Delerna]

null is a value that means that the field that has the value null has never had a value assigned to it.

nz is a function that enables you to return a default value for a field that has a null value


so if fld=null
nz(fld,"Hello")=Hello

if fld="Welcome"
nz(fld,"Hello)=Welcome

But Im sure you have seen desriptions like that before.
Maybe it would be better if you described your understanding and what you were having trouble with?

[missinglinq]

Although we speak of "null value," in point of fact, Null actually means without any value.

Linq ;0)>

[loisk]

Although we speak of "null value," in point of fact, Null actually means without any value.

Linq ;0)>

Hi Delerna and Missinglinq,

I have a variable, data typed as variant in my sub. If this field is either untouched or blank (after deleted), if statement will be running when the event is recognized. The behavior was different between 'Isnull(myField)' Nz(myField) and I didn't understand why. Thanks!