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.
[vba]Error: I am getting Automation Error for the below code.
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