[AccessD] How to Hide Existing Text Boxes and Labels on an AccessReport

Should be no problem.  Make the label property invisible on design and set
it to visible when your condition is true. I'd put the condition test in the
Open event of the report.  Back style solid of course.  And place it in
front of the controls to hide. 

But I'll bet there's more to it than that?

R


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Saturday, March 02, 2013 7:55 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] How to Hide Existing Text Boxes and Labels on an
AccessReport

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