How to control the height of multiple subReports with varying content on a report

[WorkingVBA]

Hi,

I am working on a report that will have 16 sub-reports, one right below the other. Because of the complex nature of the calculations in the groupings it seemed easier to "build" the report using vba rather than using the report's built-in grouping ability. The issue I am running into is that there seems to be no simple way to control the height of the sub-reports. I had hoped that setting "can grow" to yes would change the height of the sub reports and move all subsequent sub reports down (Allas)

As an alternative I thought too that I might be able to set the height of the sub-report control, which would make for a tricky but not impossible bit of programming, but (Again allas) I can't seem to find a reasonable way to determine the required height of the sub-report's control.

Could anyone suggest a good way to tackle this little problem?

Thanks

 

[JHB]

Which "print" are you using - "Report View", "Print Preview" or?
Try changing it!

 

[WorkingVBA]

Thanks JHB for your comment,

The Print preview does not work (yet - I get a "You can't set the Record Source property in print preview or after printing has started" error) but I did just print it and the boxes expanded as they should.

So the Report View does not support the "Can Grow" attribute, where the Print and Print Preview do. Hmmm

Thanks

 

[JHB]

So the Report View does not support the "Can Grow" attribute, where the Print and Print Preview do. Hmmm

Don't be surprised - different "print" gives different possibility and limitation. (I can't find a smiley that shows my feelings about that !!!)