handling null values[RESOLVED]

[mebhas]

a follow up from the last problem i posted here.(btw) the last problem was solved. thanx to randem)

the database returns a null value and there is an error. i have a code to handle the null value as :

If c_rs.Fields(fName).Value = Null Then
            c_allData(c_dCount) = ""
        Else
            c_allData(c_dCount) = c_rs.Fields(fName).Value
        End If

[john24]

try using if(IsNull(...) then

[mebhas]

worked like a charm. thanx john.