J
John
Hi
I am using the following code to save the changes to a form's data in the
form's Before Update event;
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
If ctl.OldValue <> ctl.Value Then
st = st & ctl.Name & "=" & ctl.Value & vbCrLf & vbCrLf
End If
End If
Next ctl
If st <> "" Then
' Save st in a table
End If
The problem is that this code does not always work and save the changes on
some of the fields particularly the ones which are memo. Any reason why this
does not always work?
Thanks
Regards
I am using the following code to save the changes to a form's data in the
form's Before Update event;
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
If ctl.OldValue <> ctl.Value Then
st = st & ctl.Name & "=" & ctl.Value & vbCrLf & vbCrLf
End If
End If
Next ctl
If st <> "" Then
' Save st in a table
End If
The problem is that this code does not always work and save the changes on
some of the fields particularly the ones which are memo. Any reason why this
does not always work?
Thanks
Regards