Textbox names

[irlbinky]

Hi,
I was wondering if anyone can help me. I have about over 30 textboxes on a form in the following order

1A 2A 3A
1B 2B 3B

and so on with each text box named after it's grid location.
I am reading values in from a database and depending on
1. The value in field1 choose the column,
2. The value in field2 choose the row.

What I was wondering is there any way to insert text into the corresponding box like

txtbox + field1 + field2 = "hello"
i.e. txtbox + 1 + A = "hello" would result in hello being inserted in box 1A.

Any help would be appreciated as it would remove a massive amount of code.

Thanks
Cathal

 

[JustinEzequiel]

try something like
Controls("txtboxA1&quot.text = "whatever"

 

[sunaj]

have you considered using a control array for you textboxes? Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[irlbinky]

Thanks, that will work perfectly and cut down a lot of code.

thanks again
Cathal