White Space in Reports

[TheSearcher]

I have a main report which consists of 3 subreports. The top (main) report and the bottom subreport are fine. But the 2 in the middle just consist of white space if no data is present.
I've already:

• Placed "Cancel = True" on the On No Data events
• Checked "Can Shrink = true" in every aspect of the report (detail section, all text boxes etc.)
• I did the above on all subreports as well as the subs appearing in the main report.

How can I get rid of the white space?

Thanks in advance!
TS

 

[DHookom]

So, you expect the top property of the bottom subreport to decrease if the other sub reports are not present?

Are the 2 middle subreports set to a very minimal height? Can you share the design view screenshot of the main report?

 

[theDBguy]

Checked "Can Shrink = true" in every aspect of the report (detail section, all text boxes etc.)

Have you tried the opposite? Make the subforms really small/narrow and set Can Grow to Yes.

 

[June7]

As already suggested - make subforms really small (0 height), virtually a barely visible line, then position them almost touching each other, set CanGrow to Yes. Can't really completely eliminate space but maybe hardly noticeable.

 

[TheSearcher]

@theDBguy & @June7 - Fascinating. I've developed many Access reports over many years and I never had to do that before. But it worked. Thanks!

 

[theDBguy]

@theDBguy & @June7 - Fascinating. I've developed many Access reports over many years and I never had to do that before. But it worked. Thanks!

@DHookom had the same idea (re: minimal height). Glad we could assist. Good luck with your project!

 

[TheSearcher]

Sorry about that. You are correct. @DHookom - Thank you!