[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