Issue with Detail height on a report/subreport

[fredalina]

I have 12 reports that I need to make subreports within one report, and I need those 12 reports to print on two pages (single double-sided page). As it is now, it takes 2 1/2 solid sheets to print, and that is with the textboxes in the Detail and 2 footer sections (1 footer on some subreports) set to height of 0.125" (grid set at the default 25 twips). I can get away with it being 0.1"; however Access seems to have a default minimum of 0.125" and keeps defaulting back to that, so there is extra space between rows in the Detail section.

I have tried sliding the detail section bars smaller, and have tried VBA on Open event to set Me.Detail.Height (= 40, = 20, even = 10), but the extra space remains.

Is there anything I can do to work around the minimum height of the sections, or to perhaps size the entire subreport to shrink it by perhaps 5%, or even to set the page setup to print to 2 pages tall by 1 page wide?

 

[boblarson]

You should be able to tighten it up completely. If you can post a copy of the database (just the reports, queries and even blank copies of the tables) I might be able to look at it and figure out how to tighten it up.

 

[fredalina]

OK, I've dummied up my little database for you, if you don't mind looking at it. I've only left one report but it shows the issue. Thanks!

 

[boblarson]

It looks to me that line37 is the cause of the problem. You have it with a height of 0.125" and therefore it makes that extra space.

 

[fredalina]

You are very right. Sorry to waste your time; not sure how I missed it .

 

[boblarson]

You are very right. Sorry to waste your time; not sure how I missed it .

Not a waste of time - it is something easy to miss but hard to try to ask all of the different questions to track it down. It is easier for me to view it instead.