Blank pages and other questions

[Yair Sageev]

Does anyone know why access inserts blank pages in reports and how to solve
this problem?


In general, how do you control the number of pages in a report and which
page a subreport is on? Is there any way to say, ok, this is page one and I
want xyz subreports on it, this will be page 2 with such and such stuff.


What happens if the data in one subreport will overlap the placement of a
subsequent subreport? Does access automatically shift the rest of the report
down?

Thanks!

 

[Rick Brandt]

Does anyone know why access inserts blank pages in reports and how to solve
this problem?

If the sections (not the controls) of your report in desing view are wider that the
margins allow for you get every other page as a blank. Is that what you're seeing?

In general, how do you control the number of pages in a report and which
page a subreport is on? Is there any way to say, ok, this is page one and I
want xyz subreports on it, this will be page 2 with such and such stuff.

You can insert pagebreaks or use the ForceNewPage property of your sections.

What happens if the data in one subreport will overlap the placement of a
subsequent subreport? Does access automatically shift the rest of the report
down?

Anything with CanGrow enabled will push the stuff below it down to maintain the same
vertical spacing as when the control doesn't grow. This obviously complicates what
you might be trying to achieve in the second topic above.