repeat text boxes

[ted]

I would like to make 36 small text boxes across the detail. There must be
some way to repeat those text boxes without doing each individually. Also I
would like each box to be controlled by a different field in the table.
Guess what I am looking for is arrays & indexes. TIA

 

[Marshall Barton]

I would like to make 36 small text boxes across the detail. There must be
some way to repeat those text boxes without doing each individually. Also I
would like each box to be controlled by a different field in the table.
Guess what I am looking for is arrays & indexes. TIA

No such thing. You can simuulate an array of text boxes by
naming them with a common prefix and a sequentially numbered
suffix (e.g. txtQ1, txtQ2, txt!3, ..., txt!36)

Then, you can reference each one using this kind of syntax:
Me("txtQ" & x)

Creating that many text boxes is pretty tedious, but
Copy/Paste can be a big help. It might take longer, but
more interesting, if you create a little design time wizard
procedure to create, name and position the text boxes using
the CreateControl method.