[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]
[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