Fit sub reports on page

[mark curtis]

Dear all,

I have once again had to post this request as I am still struggling.

I have attached a zip file with two screen shots:

Access1.bmp is the Report Print
Access2.bmp is the Report Design

My problem is this:

I have a report with 6 subreports placed in the detail section as close to each other as possible. When I print the report as you will see from Access1.bmp, sometimes I only get the subreport headings, which makes the report look "UGLY"!

What I need to do is somehow measure the subreport when it formats and if the starting position to the bottom of thye page is less than enough to print the first two records & headings of the subreport then go to the next page and begin the print.

Thanks
Mark

 

[Travis]

See Microsoft Knowledge base article:

145780 Access 97

208541 Access 2K