Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-13-2019, 08:51 PM   #1
AnTa
Newly Registered User
 
Join Date: Sep 2018
Location: HoChiMinh, Vietnam
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
AnTa is on a distinguished road
Making boxes visible/invisible

Hello, can anyone help me with this?

I have one report, with 10 fields: TestName1, TestName2,....TestName10. And I have 10 boxes: BoxTestName1, BoxTestName2,...BoxTestName10.

I want to make the boxes visible only when the corresponding field is not null, and invisible when the corresponding field is null.

Can anyone guide me with details cuz I'm not experienced with Access.

Thank you

AnTa is offline   Reply With Quote
Old 06-13-2019, 09:13 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 3,563
Thanks: 38
Thanked 869 Times in 852 Posts
theDBguy will become famous soon enough theDBguy will become famous soon enough
Re: Making boxes visible/invisible

Hi. To hide the textboxes on the report, you can use code in the format or print event. Why do you want to do it, by the way?
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is online now   Reply With Quote
Old 06-13-2019, 10:54 PM   #3
AnTa
Newly Registered User
 
Join Date: Sep 2018
Location: HoChiMinh, Vietnam
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
AnTa is on a distinguished road
Re: Making boxes visible/invisible

Hi, cuz for different records the number of notnull fields are different.
For example:
In record A, I have 4 data from fields TestName1,...TestName4, the rest are null, so I only want Box1,..Box4 to appear in the report, the other 6 are invisible.
In record B, I have 8 data from fields TestName1,...TestName8, the rest are null, so I want Box1,..Box8 to appear in the report, the other 2 are invisible.

AnTa is offline   Reply With Quote
Old 07-11-2019, 10:29 AM   #4
KHallmark
Newly Registered User
 
Join Date: Jul 2019
Posts: 12
Thanks: 0
Thanked 1 Time in 1 Post
KHallmark is on a distinguished road
Re: Making boxes visible/invisible

Go to the Format tab, Change Shape Outline to transparent, and Shape Fill to Transparent

KHallmark is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Option boxes - Making items visible Chimp8471 Forms 7 09-22-2004 04:24 AM
Visible/ invisible text boxes in a report rbrule Reports 1 03-23-2004 01:21 PM
Making Items Visible on Invisible Wicklund Modules & VBA 4 02-03-2003 02:43 PM
Visible or Invisible andy101 Forms 1 03-10-2001 08:02 PM
Making a text box visible /invisible Ants Forms 3 08-24-2000 09:42 AM




All times are GMT -8. The time now is 01:04 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World