Access 2010 - printing extra page

Have been using Access database for invoicing since Office '97 through 2000, 2003,2007 but now have 2010 and the invoice reports are printing and extra page with header and footer but the central detail is blank on the second page - first page is correct with all detail.  The report display also shows the second page.

Don't think it is anything to do with page setup as I have tried altering margins etc. to no avail.  No other problems with printers or programs, just with Access.  Any suggestions?

|

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

If the report footer was zero height then it was no causing the problem.  If the height was anything > 0, it could(?) be the part(?) of the problem.  Ok, ok, problem resolved so I'll stop trying to figure it out.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I am the Developer of a Business-Software currently used by more then 40 Companies. The Backend is SQL-Server, the Frontend Access 2003, 2007 or 2010. The Developing is done on Access 2003. I am develloping this Software since 1995, an it is used as the mission-critical software for companies with more then 1000 employes. That said i think i am an experienced user of Access.

There are many reports, which prints only one Page in Access 2003 and 2007, but the Page plus one empty Page in Access 2010. As this happens on more then 10 different Computers with various Printers i am quite shure, that is a bug in Access 2010.

It has nothing to do with Margins, because it works fine with the same Data and exactly the same Properties in Acsess 2003 ans 2007.

So, when will Microsoft awake and publish a Service Pack or something like that?

Sorry for my bad english, it is not the language i usually use.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I have to agree with Ingenieur1961 that the problem must be with Windows7/Access 2010.  We have been using these reports for years and have never had this problem.  It is only since installing Windows7/Access2010 that the extra page printing occurred.  Also other terminals using WindowsXP/Access2003 still do not have a problem. It was only when I removed the report footer/header that A2010 stopped printing the extra page. The only other possibility is new printer drivers for Windows7 - is this likely?

However, as stated above, the problem seems to be resolved for us.  Over to Microsoft

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I am having the same issue - fine with Access 2003, but not with Access 2007 . . . seems to be when I use a background color on a page header or footer. 

Interesting note . . . when you put page x of xx at the bottom of your page footer it will display that correctly.  So if my report is 3 pages long 6 pages print out - page 1, 3, and 5 are what I want with pages 2,4,6 being the blank sheets (other than a slight page header or footer color blotch).  However, at the bottom of page 1 it says "Page 1 of 3" and page 3 says "Page 2 of 3" and page 5 says "Page 3 of 3".  No footer on the junk printout pages.  I can get rid of this by getting rid of my page header or footer background color . . .

Interesting - sounds like an Access 2007/2010 issue . . .

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I had the same problem - reports that worked fine in Access 2000, XP, 2003 and 2007 print an extra page consisting of the page header and footer in Access 2010. It occurs only on those reports that contain a group footer with the Force New Page property set to After Section. If I change Force New Page to None or remove the report header and footer, the problem goes away. Does not occur with reports that have a group footer and no Force New Page property, but as soon as you set a Force New Page property, the report starts adding an extra page.

My resolution will also be to remove the report header and footer. I'll just have to move any titles in the report header to the page header. It does seem to be something unique to Access 2010. Hopefully MS comes out with a fix in their first service pack. Thanks Tim for posting the fix you found. I can make this change rather easily.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

The report header should(?) not have anything to do with it.  Using ForceNewPage After Section in a group footer will cause a blank page at the end if there is no report footer or if the report footer has ForceNewPage set to Before Section.

I strongly prefer to set the group header's ForceNewPage to Before Section instead of the group footer's to After Section.

I don't think you should have to eliminate the report header.  Try just making the report footer invisible.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I figured it out! I was trying to print a form and have a footer attach to each page and was getting an extra page to appear, just as you describe. To get the extra page to go away, all I did was set the Form Detail [Force New Page] property to <Before Section>. This does not force pages between itself and the page header / page footer. I have the form header and form footer only display on form view ([Display When] = <Screen Only>). I pretty much copied the form header/footer stuff into the page header/footer and walla, it works.

Once again: Set Form Detail [Force New Page] property to <Before Section>.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thank you so much jbrumbau.  This worked.  Microsoft acknowledged this problem but gave no solution. 

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

To all:

I have just spent several hours trying to format a report in Access 2010 so that it will print properly. Frankly, I have never worked with Access 2007 (skipped directly from Access 2003) so I can't comment on what may have changed from 2007 to 2010.  

My issue was this:the first page of my report needs to show information from one table in the Detail Section of the report. Below that information is a subreport (a continuous form/report) that displays detail lines from a related table. The first page of the report can display about 12 detail lines, and the second page of the report (without the info from the first table) can show about 20 detail lines. 

The subreport has a header showing the column headings. The subreport header needs to print on every page. Some records have only a few detail lines, others have dozens, so I cannot predict in advance how many detail lines will be needed in each report. 

I was encountering lots of different behavior as I worked at formatting the report: the first page would only print the info from the first table, and the detail lines would start on the second page. Or, after adding a page break after the subreport, the detail lines would print right after the main information (desired behavior), but I would then end up with a blank page at the end of the report. Or, in one instance, 12 detail lines printed on the first page, 2 printed in the second page, and 3 more printed on the third page. 

After reading this thread, I poked around a little and discovered that in my report, I have the following sections that have formatting properties: Page Header, Detail Header, Sub Report Header, Sub Report Page Header, Sub Report Detail Header.  

For each section, the following properties exist: Can Grow, Can Shrink, Keep together, Force New Page, and Auto Height.  Force New Page actually has a choice of four settings. In addition, I have the option of inserting a page break in several of the sections. 

So, altogether, I have about 600 formatting options I can choose, each of which may produce a different result in my report. 

I suspect that this is many more formatting options than existed in earlier versions of Access, although I have not tested that theory. 

Fortunately, I was able to get my report to work correctly after trying only a handful of the formatting options. In my case, the key was to remove all page breaks, shrink the size of my subreport to its smallest possible size (I had tried stretching it to see if that would cause the pages to break properly), then going to the property sheet of the subreport and setting Can Grow to Yes. 

Best of luck to all in formatting their reports. Perhaps someone will write an "Access 2010 Report Formatting Bible" that will explain in clear and understandable language what each formatting option does and how it affects the report output. 


Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I too had this issue and was running two instances of access on my computer.  2007 and 2010 and only had the issue with 2010.   I removed the report header from the report and bingo, the second blank page disappeared.  thanks for the info, i can now keep my hair.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

 
 

Question Info


Last updated April 8, 2021 Views 19,043 Applies to: