Testing Null value?

[pdbowling]

Hi all.

I have a query that returns lots of data.
I assign the recordset fields to variables.

Some of the fields come back null (some date fields).

I need to know which ones are null so I can assign something to them.

I tried this.

if myDateVariable is null then
do this code
end if

it gives me an 'Object Required' error

I tried

if myDateVariable = null then
do this code
end if

This skips the if statement even though I clearly see the variable is null when I test it at the stop point just before this line.

I even tried

if myDateVariable is empty then
but that failed as well.

What should I be doing?
Thanks everyone.
PB

 

[spacepro]

have you tried

If IsNull(myDateVariable) Then
do something here
End If

Andy

 

[Mile-O]

The Nz() function is useful also for assigning a specific value.

i.e.

If Nz(myValue, "bla") = "bla" Then

 

[pdbowling]

Thanks

Syntax, Syntax, Syntax.
HeHe
PB