Evenly vertically spacing records on each page

[Sam D]

Hi and thanks for reading!

I"m working on a school's reporting system. Each page of a student's report
contains 2 subjects (part of the school's requirement), where each subject
is the detail section of a subreport on the main report. Every subject
generates a detail section that is a different height.

My problem is how to calculate and then set the appropriate amount of space
between the two detail sections on each page, so they are not bunched at the
top of the page.

OnPrint for the detail section provides the correct top and height values to
calculate the remaining space on the page, but I'm stumped as to how to
reformat each page using my new spacing values!

Regards,

Sam

 

[Marshall Barton]

I"m working on a school's reporting system. Each page of a student's report
contains 2 subjects (part of the school's requirement), where each subject
is the detail section of a subreport on the main report. Every subject
generates a detail section that is a different height.

My problem is how to calculate and then set the appropriate amount of space
between the two detail sections on each page, so they are not bunched at the
top of the page.

OnPrint for the detail section provides the correct top and height values to
calculate the remaining space on the page, but I'm stumped as to how to
reformat each page using my new spacing values!

I've been thinking about this and can not come up with a way
to do that. The CanGrow height is not known until the Print
event, but that is too late to adjust the position, size or
visibility of controls.

Can yo get away with just adding some white space between
the two subreports?

 

[Sam D]

Thanks Marsh,

I do have one possible strategy in mind...

1. Preview the whole report and calculate and store all the spacings during
print events. And then close it.
2. Start again but this time make the space adjustments in the format
events.

This would take some work, so I'll see how time goes before attempting.
Otherwise, simply adding some white space will work for most pages.

Sam