Access basic 97
Access basic 97
(OP)
I have a form with several text boxes on it. Is there any way to clear all of the text boxes at once without individually setting their .text = ""?
Are you a
Computer / IT professional?
Join Tek-Tips Forums!
Computer / IT professional?
Join Tek-Tips Forums!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts - Keyword Search
- One-Click Access To Your
Favorite Forums - Automated Signatures
On Your Posts - Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Talk To Other Members
RE: Access basic 97
Sub ClearForm()
Dim frm As Form, ctl As Control
' Set the current form as the target
Set frm = Screen.ActiveForm
' Enumerate Controls collection of each form.
For Each ctl In frm.Controls
' Print name of each control.
If ctl.ControlType = acTextBox Then
ctl = ""
End If
Next ctl
End Sub