By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,779 Members | 1,291 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,779 IT Pros & Developers. It's quick & easy.

How to delete the last page from report which is blank

P: 1
I have updated from MSAccess 2003 to 2010 and some features i donot understand yet.
i am wondering when print ing the reports last page is printing blank with page footer comments.

i am wondering how i can delete this page. i have auto page Numbers on Bottom and if we add the text data it aoutomatically increase the page number but when i reduce the data/ less rows it didnot shrink the page.
Oct 2 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 5K+
P: 5,397
Weird problem.
Would you please check two things:
Width of the report page in design mode (just for me :) )
Where/how/iif-any - group/page/header type page breaks.
Oct 2 '12 #2

Expert Mod 100+
P: 2,321
Please when you post take the time to read over your own post, and fix any typos you have. It makes it easier for us to read, and it shows that you mean business.

As zmbd has allready said, ensure that your report width (+margins) is not wider then page width. Access will usually give a warning if this is the case, the warning can be seen as a small green triangle in the upper left corner of the report while in design view. This can cause extra pages to appear, but it will be alot of extra pages, 1 extra page per "normal" page.

Ensure that when your are viewing the report you are doing so in Print Preview, and NOT Layout View. Layout view can give some really unreliable results at times.

You can have page breaks before after group header and footers, as well as before or after Report Header/Footer. Ensure that you have not by accident turned any of these on where they are not meant to be.

If none of the above works, I suggest you take a screenshot of the report in design mode and in Print Preview mode and attach both.
Oct 2 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.