Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Re: Concatenating



If you've got the control name stored in a variable strControl, try:

Forms![frmName].Controls(strControl).Visible = True



-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"Bob Rice" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I need to have the controls (images) in the form, frmName evaluated to
find
> out which ones will be made visible.  The names of the controls are
> Image51X, Image51Z, Image52X, Image52Z, etc.  The code needs to read:
>
>  Do While...
>   Forms![frmName].[??????].Visible = True
>   .MoveNext
>  Loop
>
> I am unable to get the syntax correct to increment to image names.
>
> -- 
> Bob Rice
> www.geocities.com/arrice.geo
>
>





<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.