Private Sub Adodc1_WillChangeRecord( _
ByVal adReason As ADODB.EventReasonEnum, _
ByVal cRecords As Long, _
adStatus As ADODB.EventStatusEnum, _
ByVal pRecordset As ADODB.Recordset)
Dim int1 as integer
For int1 = 0 To pRecordset.Fields.Count - 1
If IsNull(pRecordset.Fields(int1).Value Then
If pRecordset.Fields(int1).Type = adChar Then
pRecordset.Fields(int1).Value = ""
Else
pRecordset.Fields(int1).Value = 0
End If
End If
Next int1
End Sub