For Each Loops help!!

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.

Code:

---

Dim txt As Control

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

---

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

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