Need help w/ Clearing Form

  • Thread starter Thread starter David Ehrenreich
  • Start date 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
 
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.
 
Back
Top