Need help w/ Clearing Form

  • Thread starter David Ehrenreich
  • Start date
D

David Ehrenreich

Hello,

I would like to add a procedure on the On Change
expressions that would clear the form of any text
entered. It can not be a new record.

Any help would be great

Thank you
David Ehrenreich
 
E

Eric D.

Hey,

Try this:
========================
Dim ctrl As Control

For Each ctrl On Me.Controls
If ctrl.ControlType = acTextBox Then
ctrl.Value = ""
End If
Next ctrl
=======================
Hope this helps.
 
Top