Gather information about all the controls available in a FORM

[manoj_mandy]

Can any one send me the method by which one can collects the information about all the controls available in a form. I want to know about all the controls available in my form or any other forms.

Manoj Kumar
mandy_manoj@rediffmail.com

[Sam2s]

There is a controls collection available on your form which can be stepped through. Try this out for size - can be adapted to fit the type of information you want from each control:

Dim cItem As Control

For Each cItem In Me.Controls
Debug.Print TypeName(cItem) & ", " & cItem.Name
Next cItem