Text box name & variables

[Greg Franke]

I have a form with several text boxes that I need to update values in.
Example

form_form1.Text_1_A
form_form1.Text_1_B
form_form1.Text_1_C

form_form1.Text_2_A
form_form1.Text_2_B
form_form1.Text_2_C

etc.
What I want to do is be able to use a variable inplace of a hardcoded number
like this.

form_form1.Text_(variable)_A
form_form1.Text_(variable)_B
form_form1.Text_(variable)_C

any ideas?

Thanks

 

[Graham Mandeno]

Hi Greg

You can refer to the member of any collection using a string in parentheses,
and the string can be an expression.

So you can use this syntax:

Form_form1("Text_" & intNumber & "_" & strLetter)

 

[Chris Nebinger]

Form_Form1.Controls("Text_" & Variable & "_A").Value


Chris Nebinger

 

[Greg Franke]

Thanks Graham!

Took me a few tries to get it right but it is working great!

Thanks again for your help!

Greg

Hi Greg

You can refer to the member of any collection using a string in parentheses,
and the string can be an expression.

So you can use this syntax:

Form_form1("Text_" & intNumber & "_" & strLetter)
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

I have a form with several text boxes that I need to update values in.
Example

form_form1.Text_1_A
form_form1.Text_1_B
form_form1.Text_1_C

form_form1.Text_2_A
form_form1.Text_2_B
form_form1.Text_2_C

etc.
What I want to do is be able to use a variable inplace of a hardcoded number
like this.

form_form1.Text_(variable)_A
form_form1.Text_(variable)_B
form_form1.Text_(variable)_C

any ideas?

Thanks