i have some comboboxes and some textboxes on a form
i would like to clear all of them with one line of code. is that possible?
something like all_controls.text=""
views:
24answers:
1
+3
A:
Not with one line of code. You will have to walk through all of the controls with a loop.
Dim ctl As Control
For Each ctl In Me.Controls
If (ctl.ControlType = acTextBox) Then
ctl.Value = Null
End If
Next ctl
Robert Harvey
2010-05-14 21:08:53
If you're doing this often, say in an unbound form that is used in a query-by-form interface, it's vastly faster to assign the controls you're clearing to a custom collection in the OnLoad event of the form, and then walk that collection instead of the entire controls collection.
David-W-Fenton
2010-05-15 19:19:39