John W Colby
jwcolby at gmail.com
Sat Mar 2 22:04:24 CST 2013
And I would use classes and a framework so that I could repeat it on the next report in a few lines of code. ;) John W. Colby Reality is what refuses to go away when you do not believe in it On 3/2/2013 4:16 PM, William Benson wrote: > 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 >> >>