For Each Loops help!!

[Dillinger4]

ok ok now that i got your attention. well it's not that bad
{{{laughing}}}
im trying to just simply trying to print out a list of textbox names that are on a form but all i can figure out
is how to print every control name on a form.

Dim txt as Object
For Each txt In frmAccountSetup.Controls
Debug.Print txt.Name
Next txt

' is there anyway to get just the textbox names??
Thanks All

Use TypeOf to check if it's a TextBox.

Dim txt As Control

For Each txt In Controls
    If TypeOf txt Is TextBox Then Debug.Print txt.Name
Next txt

[anilgoje]

Hi Dilenger4,
Yes there is solution to find the names of all the textboxes present in a form.Here is the code..

Dim ctl As Control

For Each ctl In Me.Controls
If TypeOf ctl Is TextBox Then
Debug.Print ctl.Name
End If
Next

Hope this will help you

Regards

[Dillinger4]

Ahhhhhhhh. I has once again been enlightened!
Thanks..... =C)