I'm trying to retrieve the properties collection of a control collection, and my code is giving me the "object doesnt support this property or method" error. Anyone know why ?
Dim objForm as Form
Dim objControl As Control
Dim objProperties As Property
For Each objControl In objForm.Controls
Debug.Print TypeName(objControl) & ": " & objControl.Name
For Each objProperties In objControl.Properties <-----ERRORS HERE
Debug.Print "Properties for " & objControl.Name & ": " & objProperties.Name
Next
Next
Dim objForm as Form
Dim objControl As Control
Dim objProperties As Property
For Each objControl In objForm.Controls
Debug.Print TypeName(objControl) & ": " & objControl.Name
For Each objProperties In objControl.Properties <-----ERRORS HERE
Debug.Print "Properties for " & objControl.Name & ": " & objProperties.Name
Next
Next