Solved: How to edit field values in ADO recordset ?

[sagotianitin]

Hi guys,

Please anyone can help on the below issue.

Issue: I need to update the fields value to "Blank" wherever field in recordset has NULL.

Error: I am getting Automation Error for the below code.

[vba]
Do While Not .EOF
For Each ObjField In .Fields
If IsNull(ObjField.Value) Then
rst.Fields(ObjField.Name).Value = "Blank"
End If
Next ObjField
rst.MoveNext
Loop
[/vba]

Kindly let me know where I am wrong! or more information is needed.

Thanks