Arrays and text boxes

[MattCollins]

Is there anyway to name text boxes in an array format?

i.e. Text(1,23)

Or if not is there anyway to use VB to cycle through the text boxes

i.e
i = 1
Loop until i = 25
Text(i) = codehere
i = i + 1
Exit Loop

Matt

 

[KeithG]

Are there any other controls on the form? If not you could loop through the Controls collection of the form.

 

[MattCollins]

There are other controls on the form unfortunately.

 

[allan57]

Create the text fields you wish to loop through i.e.

txtFieldName_1
txtFieldName_2
txtFieldName_3
txtFieldName_4
etc

i = 1
Loop until i = 25
me(“txtFieldName_” & i) = codehere
i = i + 1
Exit Loop