Access World Forums

Access World Forums (https://www.access-programmers.co.uk/forums/index.php)
-   Reports (https://www.access-programmers.co.uk/forums/forumdisplay.php?f=10)
-   -   Empty space when .visible = False (https://www.access-programmers.co.uk/forums/showthread.php?t=306715)

Lkwdmntr 09-05-2019 08:43 AM

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?

theDBguy 09-05-2019 08:54 AM

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.

Lkwdmntr 09-05-2019 09:23 AM

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?

theDBguy 09-05-2019 09:30 AM

Re: Empty space when .visible = False
 
Quote:

Originally Posted by Lkwdmntr (Post 1638994)
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?

Mark_ 09-05-2019 09:55 AM

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.

Lkwdmntr 09-05-2019 10:07 AM

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.

theDBguy 09-05-2019 10:28 AM

Re: Empty space when .visible = False
 
Quote:

Originally Posted by Lkwdmntr (Post 1639001)
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!

Lkwdmntr 09-05-2019 11:41 AM

Re: Empty space when .visible = False
 
Worked like a charm, thanks for the inspiration.

theDBguy 09-05-2019 11:56 AM

Re: Empty space when .visible = False
 
Quote:

Originally Posted by Lkwdmntr (Post 1639010)
Worked like a charm, thanks for the inspiration.

Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.


All times are GMT -8. The time now is 11:04 AM.

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