Question Regarding Null values in a RS [RESOLVED]

[kidlaley]

i create a recordset (RS) and sometimes the fields return a Null value.. the thing is that when i want to pass the value to a variable, it gives me an error...

i have try an if statement something like this
if rs.fields("Something") = Null then
Variable = 0
else
variable = rs.fields("Something")
end if

but the thing is that vb executes the else line!!!!

how can i catch the Null Value????

help please

Thanks

[jim mcnamara]

use :

if rs.fields("SOMETHING) is NULL then

NULL is never equal to anything including itself.

[kidlaley]

i get this error.. 'Object Required'

heres my code

If RS.Fields("Date Complete (estimate)") Is Null Then
   LItem.SubItems(4) = "???????"
Else
   LItem.SubItems(4) = RS.Fields("Date Complete (estimate)")
End If

error occurs on the first line

HELLLLLLPPPPP

[kidlaley]

I used the IsNull() and it work perfect...

i had it to get a thick vb book in order to find it but i got it!!!!

thanks for the help!!!!