<div>
<br />
dim i as integer<br />
<br />
for i=1 to 31<br />
&nbsp; &nbsp;me(&quot;txtday&quot; &amp;&nbsp;i)=&lt;values&gt;<br />
<br />
next
</div>



dim i as integer

for i=1 to 31
   me("txtday" & i)=<values>

next

<div>
<br />
Me.txtday &amp;&nbsp;Trim(Stri+1)) &amp;&nbsp;&quot;.text = &quot;hi&quot;<br />
<br />
mx
</div>



Me.txtday & Trim(Stri+1)) & ".text = "hi"

mx

<div>
Me.txtday &amp;&nbsp;Trim(Str(i+1)) &amp;&nbsp;&quot;.text = &quot;hi&quot;<br />
<br />
mx
</div>


Me.txtday & Trim(Str(i+1)) & ".text = "hi"

mx

<div>
How about:<br />
<br />
&nbsp;Me.Controls(&quot;txtDay &amp;&nbsp;i +1) = &quot;Hi&quot;<br />
<br />
that works.
</div>


How about:

 Me.Controls("txtDay & i +1) = "Hi"

that works.

<div>
Sorry, Miriam, I should have refreshed.
</div>


<div>
np, Ray :-)<br />
<br />
&lt;OT&gt;<br />
Are you receiving email notifs? &nbsp;Mine (hotmail) don't seem to be working.<br />
&lt;/OT&gt;
</div>


np, Ray :-)

<OT>
Are you receiving email notifs?  Mine (hotmail) don't seem to be working.
</OT>

<div>
Working fine for me - using Outlook - Firefox as the browser.
</div>


Working fine for me - using Outlook - Firefox as the browser.

<div>
<div class="content wysiwyg-content">
I have a group of 31 text box controls and I need to be able to reference them directly i.e.<br />
<br />
The control naming convention is: txtDay1, txtDay2, txtDay3 ... txtDay31.<br />
<br />
I need to be able to assign values to these dynamically and it would seem logical to me to use:<br />
<br />
Me.txtday&quot; &amp;&nbsp;i+1 &amp;&nbsp;&quot;.text = &quot;hi&quot;<br />
<br />
...although obviously this does not work.<br />
<br />
Is there any way that I can concatinate an integer value to my text box object txtday in code?<br />
<br />
Thanks for anything.
</div>
</div>


I have a group of 31 text box controls and I need to be able to reference them directly i.e.

The control naming convention is: txtDay1, txtDay2, txtDay3 ... txtDay31.

I need to be able to assign values to these dynamically and it would seem logical to me to use:

Me.txtday" & i+1 & ".text = "hi"

...although obviously this does not work.

Is there any way that I can concatinate an integer value to my text box object txtday in code?

Thanks for anything.

Access VBA - Dynamically Reference A Text Box Control In Code

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.