Using code from Dirk Goldgar to reset all TextBoxes to Null after a cancel,
I have attempted to add code which also resets the BackColor of certain
previously changed controls. My added code works fine up to the point after
the last mis-colored control is reset, but then it crashes with the message
"Object doesn't support this property or method." Since all the affected
controls have been reset at that point, I can't see why this happens. Can
someone point me in the right direction?

Dim ctl As Access.Control
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
ctl.Value = Null
'If req'd field set to Lt Red, reset to Lt Yellow
If ctl.BackColor = "13408767" Then
ctl.BackColor = "10092543"
End If
End If
Next ctl

Thanks in advance.
--
David Habercom
University of Tennessee

My apologies! To simplify my post, I did not include all three If
ControlType conditions. My actual conditions include "Or ctl.ControlType =
acCheckBox." Check boxes do not have a BackColor option, thus the crash.
The solution was to move the BackColor code to a 2nd If ControlType
(following the first) which excludes acCheckBox.

I frequently discover my own error while writing a post to these groups, but
this time I figured it out too late!

Thanks (for you patience.)
--
David Habercom
University of Tennessee