<div>
Thanks everyone. &nbsp;Worked like a charm! (what was I thinking?)<br />
<br />
Biggles
</div>


Thanks everyone.  Worked like a charm! (what was I thinking?)

Biggles

<div>
<div class="content wysiwyg-content">
I have a form with labels called lbl1, lbl2, lbl3 ....... lbl60<br />
<br />
I want to write code that will refer to each label in turn and change the caption.<br />
<br />
This code does NOT work:<br />
Dim X as Integer<br />
<br />
For X = 1 to 60<br />
&nbsp; &nbsp;Me.lbl &amp;&nbsp;X &amp;&nbsp;.Caption = &quot;X&quot;<br />
Next X<br />
<br />
I DON'T want to write 60 lines of code like this:<br />
Me.lbl1.Caption = &quot;1&quot;<br />
Me.lbl2.Caption = &quot;2&quot;<br />
Me.lbl3.Caption = &quot;3&quot;<br />
.....<br />
Me.lbl60.Caption = &quot;60&quot;<br />
<br />
Any Ideas what I am doing wrong?<br />
<br />
Thanks,<br />
<br />
Biggles1<br />

</div>
</div>


I have a form with labels called lbl1, lbl2, lbl3 ....... lbl60

I want to write code that will refer to each label in turn and change the caption.

This code does NOT work:
Dim X as Integer

For X = 1 to 60
   Me.lbl & X & .Caption = "X"
Next X

I DON'T want to write 60 lines of code like this:
Me.lbl1.Caption = "1"
Me.lbl2.Caption = "2"
Me.lbl3.Caption = "3"
.....
Me.lbl60.Caption = "60"

Any Ideas what I am doing wrong?

Thanks,

Biggles1


Change label captions in Access VBA SEQUENTIALLY

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.