<div>
I see what you want to do, but what is the field name in the query that contains the label information?<br />
<br />
mx
</div>


I see what you want to do, but what is the field name in the query that contains the label information?

mx

<div>
why not make it as control array?
</div>


<div>
Carole ... are you wanting to set the label Captions from data in the query?<br />
<br />
mx
</div>


Carole ... are you wanting to set the label Captions from data in the query?

mx

<div>
<div class="content wysiwyg-content">
I have an MSAccess form that have 10 label and 10 text fields. &nbsp;All fields are all set to invisible, and disabled, and depending on what selection the user selects, anywhere from 1 - 10 fields will become visible and the label captions will get set. &nbsp;My question is this...depending on the selection, the label captions will be set to different things. &nbsp;I want to set them using a loop. &nbsp;The labels are called lblparm1, lblparm2, lblparm3, lblparm4, etc. &nbsp; How can I set this using a loop or can I do that at all. &nbsp;Can I do something like this:<br />
for x = 1 to number of parms in query<br />
strlabel = &quot;lblparm&quot; &amp;&nbsp;cstr(x)<br />
strlable.caption = .........<br />
next i<br />
<br />
I tried this but it doesn't work. &nbsp;Is it possible?
</div>
</div>


I have an MSAccess form that have 10 label and 10 text fields.  All fields are all set to invisible, and disabled, and depending on what selection the user selects, anywhere from 1 - 10 fields will become visible and the label captions will get set.  My question is this...depending on the selection, the label captions will be set to different things.  I want to set them using a loop.  The labels are called lblparm1, lblparm2, lblparm3, lblparm4, etc.   How can I set this using a loop or can I do that at all.  Can I do something like this:
for x = 1 to number of parms in query
strlabel = "lblparm" & cstr(x)
strlable.caption = .........
next i

I tried this but it doesn't work.  Is it possible?

Is it possible to set MSAccess form object properties using variable substitution?

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.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.