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

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
>
>