Invalid Use Of Null

I’m sure everybody’s run into this problem at least once, and I’m equally sure it has an easy solution.

I’m trying to update an ADO recordset in VB, and if I try to update a field whose value is null, I get “Invalid Use of Null”. So to fix this,I go through each line of my code and add the condition “If not isnull(rs.fields(“fieldname”).value) then [update the field].

Is this really necessary? I can’t imagine that vb programmers world wide have included this seemingly useless conditionbefore each field they update.

Many thanks!