Last page on report is always blank? 2

[winston01]

When I run a report the page breaks and widths look great, but the last page on the report is always blank. What am I doing wrong?

Thank you.

 

[dhookom]

We are having issues seeing your report design, controls, section heights, page break controls, code, section property values, ...

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[winston01]

So, how do I trouble shoot this.

I do not see any reason why the last page should be blank. On a 20 page report, 19 pages are perfect. But, page 20 is blank.

Thank you.

 

[djjay]

I had this problem and found that the pages on my report were slightly too wide. try resizing them slightly and see if this clears the problem. Just worked for me

Let us know how you get on

 

[natrluvr]

Might check the report footer, make sure the height is 0 or the minimal amount of space.

Sarah

 

[winston01]

Thanks for your help everyone. This one is driving me crazy. I think it does has something to do with the report footer. When I add a footer, it prints on the last page. I assume this is because I have a page break within my grouped information. But, I deleted the report footer and the last page still shows. I made sure I am not beyond the page width as well.

Anymore ideas on how to trouble shoot?

Thank you.

 

[dhookom]

Now we know a little more about your report, properties, and controls (specifically the Page Break). You should consider removing the page break and using the Force New Page property of your group sections.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[winston01]

Thank you, deleting the page break took care of the problem. I appreciate your help.

 

[traycee]

Thanks, this worked great for me, too. I've never used that property before.