Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-05-2019, 08:43 AM   #1
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 105
Thanks: 2
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Empty space when .visible = False

Hello Guys,

I ran into a little snag. I have a subreport that will move to the second page along with labels for the columns. I have the page break and the labels appear when the record count is over a certain amount and then hide the labels and the break if the count is under the amount. Everything works fine when the record count is over, but my problem is when the count is under the amount, the labels hide but leave a blank space where they were.

Is there any way that I can get rid of the dead space when the labels are hiding?

Lkwdmntr is offline   Reply With Quote
Old 09-05-2019, 08:54 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,905
Thanks: 57
Thanked 1,291 Times in 1,272 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Empty space when .visible = False

Hi. The only thing I could think of is maybe set the label height to a minimum and then adjust the height as you make them visible. So, when they're hidden, they don't occupy too much space.
__________________
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 09-05-2019, 09:23 AM   #3
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 105
Thanks: 2
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Empty space when .visible = False

Sounds like a great idea, I tried it and I still have the space. Any other suggestions? Could I move the subreport up somehow?

Lkwdmntr is offline   Reply With Quote
Old 09-05-2019, 09:30 AM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,905
Thanks: 57
Thanked 1,291 Times in 1,272 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Empty space when .visible = False

Quote:
Originally Posted by Lkwdmntr View Post
Sounds like a great idea, I tried it and I still have the space. Any other suggestions? Could I move the subreport up somehow?
Hi. You'll never be able to get rid of the space, I don't think, because the object is still there, just hidden. Have you tried using 0" height?
__________________
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 09-05-2019, 09:55 AM   #5
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 2,045
Thanks: 20
Thanked 382 Times in 375 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: Empty space when .visible = False

Do you have the labels in the header of the subreport? If so, you should be able to set the headers height to 0 so they won't print.
Mark_ is offline   Reply With Quote
Old 09-05-2019, 10:07 AM   #6
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 105
Thanks: 2
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Empty space when .visible = False

No, but you did give me an idea. I can add the labels I'm using as a heading into the subreport header. Then Make that appear or disappear according to the count. I'll try it and let you know if it worked.
Lkwdmntr is offline   Reply With Quote
Old 09-05-2019, 10:28 AM   #7
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,905
Thanks: 57
Thanked 1,291 Times in 1,272 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Empty space when .visible = False

Quote:
Originally Posted by Lkwdmntr View Post
No, but you did give me an idea. I can add the labels I'm using as a heading into the subreport header. Then Make that appear or disappear according to the count. I'll try it and let you know if it worked.
Hi. Sounds like a good plan. Good luck!

__________________
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 09-05-2019, 11:41 AM   #8
Lkwdmntr
Newly Registered User
 
Join Date: Jul 2019
Posts: 105
Thanks: 2
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
Re: Empty space when .visible = False

Worked like a charm, thanks for the inspiration.
Lkwdmntr is offline   Reply With Quote
Old 09-05-2019, 11:56 AM   #9
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,905
Thanks: 57
Thanked 1,291 Times in 1,272 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Empty space when .visible = False

Quote:
Originally Posted by Lkwdmntr View Post
Worked like a charm, thanks for the inspiration.
Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.

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

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Me.Visible=False not working jsic1210 Forms 5 09-13-2013 09:41 AM
Set Focus & Visible = False sly like Coyote Forms 18 04-23-2010 07:36 AM
Form.visible = false Skip Bisconer Forms 5 06-16-2008 08:48 PM
CheckBox.Visible = False dawkirst Modules & VBA 6 09-26-2005 09:44 PM
Can I set table.visible = false sambo Modules & VBA 11 09-16-2002 09:18 PM




All times are GMT -8. The time now is 02:58 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