repeat text boxes

  • Thread starter Thread starter ted
  • Start date Start date
T

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
 
ted said:
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
Click to expand...


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.
 
Back
Top