How to find only the bound controls in a form?
I tried using "For each control in form.controls"
The problem is Labels don't have the controlsource property at all.
How to find only the bound controls in a form?
I tried using "For each control in form.controls"
The problem is Labels don't have the controlsource property at all.
[VBA]
For Each ctl In Me.Controls
' depends which controls you want to check - may need to add
' check boxes and list boxes as well
Select Case ctl.ControlType
Case acTextBox, acComboBox
' ...
End Select
Next ctl
[/VBA]
We are what we repeatedly do. Excellence, therefore, is not an act but a habit.
Aristotle
Posting Permissions
Reply With Quote
