Access the Control Source of txtBox by variable?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several txtBoxes that I want to edit the Control Sources of each of
them. If I set a variable to the name of the txtBox, can I somehow
dynamically call the control source of the txtBox by a variable as suppose to
writing out the code for each one in long form? Confused? Here's my code

Option Explicit
Dim SomeFormula

Me.txtBox.controlsource = "=" & SomeForumula

Can I somehow do this:

Me. & Array(I) & .controlsource= "=" & SomeFormula

Is this possible? Still Confused? (So am I sometimes...)
 
I also want to know if it's possible to set a variable to equal a control
source based on a variable?

dim x

x=Me. & var1 & .ControlSource.Text

Can this be done without actually typing the txtboxes name as to using a
variable in its place? Thanks.

Kou
 
In
Kou Vang said:
I have several txtBoxes that I want to edit the Control Sources of
each of them. If I set a variable to the name of the txtBox, can I
somehow dynamically call the control source of the txtBox by a
variable as suppose to writing out the code for each one in long
form? Confused? Here's my code

Option Explicit
Dim SomeFormula

Me.txtBox.controlsource = "=" & SomeForumula

Can I somehow do this:

Me. & Array(I) & .controlsource= "=" & SomeFormula

Is this possible? Still Confused? (So am I sometimes...)
Click to expand...

You can use the name of the control as a string index into the Controls
collection; like this:

Me.Controls(Array(I)).Controlsource = "=" & SomeFormula
 
In
Kou Vang said:
I also want to know if it's possible to set a variable to equal a
control source based on a variable?

dim x

x=Me. & var1 & .ControlSource.Text

Can this be done without actually typing the txtboxes name as to
using a variable in its place? Thanks.
Click to expand...

Use:

x = Me.Controls(var1).ControlSource

There is no ".Text" property of the ControlSource, which is itself a
text property.
 
I forgot to mention that I am trying to edit txtBoxes that are in a report
through a form I am running. Can I open a report while running the code from
the form, and edit the txtboxes of the report through the forms code?

Kou
 
In
Kou Vang said:
I forgot to mention that I am trying to edit txtBoxes that are in a
report through a form I am running. Can I open a report while
running the code from the form, and edit the txtboxes of the report
through the forms code?
Click to expand...

I think you'd better put the code to modify controlsources in the Open
event of the report. Even if Access will let you do it after the
report's Open event has finished -- and it may not -- I'm not sure if
there's any other way for you to ensure that the text boxes'
controlsources are set before the report actually starts to print them.
 
Back
Top