Set up text boxes in MS Access form as array?

Question

Is there a way to set up text boxes in Access forms as arrays for use in loops with VBA?

Answer 1

You can access the controls and iterate through them. Have to pick an iterable naming scheme.

Me.Controls("txt" & intloop)

Answer 2

I would disagree with serakfalcon in terms of requiring a certain naming schema to iterate through textboxes. The proper way would be to look at the control type. It should really be done like this:

Dim ctl As Access.Control

For Each ctl In Forms!MyForm.Controls
    If ctl.ControlType = acTextbox Then
         '...your code here.
    End If
Next

This does not require a specific naming schema (not saying it is a bad idea, it isn't) and you know for sure the object is what you are expecting.