Or if i try the following an exception is also thrown
72: If objRecordSet("AccountNumber") Is Nothing
73: Then Response.Write " "
74: Else Response.Write "" & objRecordSet("AccountNumber") & ""
75: End If

Freon22

You really didn't show enough of your code to see where you maybe making mistakes. I guess you are checking to make sure that there is something in your record set with eof. and you are not closing the recordset before you get to line 72. Also is this If statement inside of a loop? Anyway try this

If IsNull(objRecordSet.fields("AccountNumber").value) = False Then
Response.Write(objRecordSet("AccountNumber"))
Else
Response.Write("The field value for AccountNumber is empit")
End If