Mystery Blank Page

[Roncayenne]

This is killing me and do not know where it is coming from.
I have a main report with 2 subreports. Each subreport only has a detail section. Main report has a bottom page section with the system date. Main report has a main query with a location field. Each of the subreports has the same field. I have the parent/child setup on this field.

The report is suppose to print info for each location on one page,then go to the next page and print location info for the next location.

It is printing info correct and on each of the location pages it is printing the page date at the bottom, then a complete blank page. Then goes to the next location and blank page,etc. The report seems like it takes a long time to run like it is running the complete queries all over for each location. The blank page is a mystery.
Sorry for so long winded, but thats most of the info.
Can anyone help? On the main report I have a location footer set to page break 'after section' and seems to work.
Oh, the sections and the length of the page is short. I check this first.

Thanks for the help in advance....
Ron

 

[LonnieJohnson]

Could it be the width of the main or sub reports. I have often had blank pages when I was just a hair over the width for my report. This can be compensated by either decreasing the margins in the page setup or expanding the width of the report in design view.

Just a thought. Hope it helps.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!