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