William Benson
vbacreations at gmail.com
Sat Mar 2 15:16:49 CST 2013
Nope been that way for generations. Still I would probably have tagged the controls involved and using Boolean logic set their visible property by looping through all controls having a tags with that value to visible equals true or false as appropriate. Seems cleaner to me. On Mar 2, 2013 11:58 AM, "Brad Marks" <BradM at blackforestltd.com> wrote: > All, > > You folks are GREAT, even on the weekend! > > I was trying to find the "Bring to Front" in the Property Sheet for the > new Label. > > I then found it via "Right Click / Position / "Bring to Front" > > I had not used this before. I try to learn one new thing every day and I > have accomplished this goal before noon today. > > Thanks for your assistance. I appreciate it. > > Brad > > PS. I use Access 2007 which may be different than other Access versions > in how this is done... not sure. > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com on behalf of John Bodin > Sent: Sat 3/2/2013 10:11 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] How to Hide Existing Text Boxes and Labels on an > Access Report > > Hi Brad, > > You s/b able to create your label with the text you want to show, set the > Back Style to 'normal' and then after you move it to the position to cover > up the 40 text boxes/labels, make sure you choose to Format/Bring to Front. > Then just hide/show that label depending on how the report is chosen to > run by the user. > > John > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com [mailto: > accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks > Sent: Saturday, March 02, 2013 10:55 AM > To: Access Developers discussion and problem solving > Subject: [AccessD] How to Hide Existing Text Boxes and Labels on an Access > Report > > All, > > I have a complicated one-page report that has many Text Boxes and Labels. > > Recently a need has surfaced, where I need to temporarily "hide" a section > of this report (about 40 text boxes and labels). > > The need to hide these controls may occur once or twice a month. > > Instead of making the 40 controls "invisible", I was hoping to simply add > a new Label to cover up the existing 40 controls. Also, the new label > would have text to explain why the 40 controls are not being shown. > > Is there a way to do this? I have reviewed the "Property Sheet" for the > new label but I can't see how to make this happen. > > Thanks, > Brad > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >