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

Rocky Smolin rockysmolin at bchacc.com
Sun Mar 3 00:05:13 CST 2013


It's also in the format menu, Align sub-menu.  I use the keyboard shortcut
Alt-O-A-T.

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 8:52 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to Hide Existing Text Boxes and Labels on
anAccess Report

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.







More information about the AccessD mailing list