PDA

View Full Version : How to find only the bound controls?



prabhafriend
07-21-2010, 09:24 AM
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.

geekgirlau
07-21-2010, 03:26 PM
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