sagotianitin
03-26-2013, 11:47 AM
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.
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
Kindly let me know where I am wrong! or more information is needed.
Thanks
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.
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
Kindly let me know where I am wrong! or more information is needed.
Thanks