Brad Marks
BradM at blackforestltd.com
Sat Mar 2 10:52:28 CST 2013
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.