Question Regarding Null values in a RS [RESOLVED]

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

use :

Code:

---

if rs.fields("SOMETHING) is NULL then

---

NULL is never equal to anything including itself.

i get this error.. 'Object Required'

heres my code

VB 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 :( :( :(

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!!!!