Dynamically Build Object Name

[Guest]

I am attempting to use a variable to help determine the name of a text box,
so that I can then manipulate the object. For example:

Variable1 = 31
me.txt & [variable1] = "Test"


I have a form w/ a series of 56 text boxes, and this seems it would be much
easier than attempting something like a Case statement.

Any assistance is greatly appreciated.

Sharkbyte

 

[Guest]

I'm not quit sure what you are trying to accomplish but you could loop
through the controls on the form and retrieve the name via the control name
property.

Try something like:

dim ctl as control

for each ctl in me.form
debug.print ctl.name
next ctl

Instead of printing it in the immediate window you can decide what to do
with it.

hth

 

[George Nicholson]

Me.Controls("txt" & variable1) = "Test"

HTH,

 

[John W. Vinson]

I am attempting to use a variable to help determine the name of a text box,
so that I can then manipulate the object. For example:

Variable1 = 31
me.txt & [variable1] = "Test"


I have a form w/ a series of 56 text boxes, and this seems it would be much
easier than attempting something like a Case statement.

Any assistance is greatly appreciated.

Sharkbyte

Try

Me.Controls("txt" & Variable1)


John W. Vinson [MVP]