Report PDF

[sbaud2003]

I have to convert a report which consist of only one page, but every time it convert gets a blank page. However, the first page contain the page number as 1 of 1 only. I could not resolve, please help

 

[theDBguy]

Can you share a demo db to show the problem?

 

[The_Doc_Man]

Check whether the first report section on the page has a "force new page" set. (It's one of the section properties.)

Section.ForceNewPage property (Access)

Office VBA reference topic

learn.microsoft.com

 

[Pat Hartman]

Also, your layout may exceed the width/length of your page.

 

[561414]

Troubleshoot by creating a report that just says "Hi". With just that little word, do you still get two pages? If not, then gradually add more stuff and see where the limit is. I've also had the issue where the printer pulls two sheets, so figure that out too.

 

[The_Doc_Man]

I've had the problem before that when selecting different printers, some will add a blank page and others will not. It has to do with the native resolution of the printer and the fact that even if only one "twip" that is part of the bottom margin overflows past the printer's page limits, you get a blank page. It will depend on the exact dot size of the printer. Most of the ink-jet printers will have the same resolution, but if there is a laser-jet printer in the mix, it can be different. Even similar brands from different makers can have this problem.

When you are ready to print, as a test try to enter Print Preview mode to see where things will come out. When you step through the expected pages, you would easily find that "overflow" page if there is going to be one.

 

[sbaud2003]

Troubleshoot by creating a report that just says "Hi". With just that little word, do you still get two pages? If not, then gradually add more stuff and see where the limit is. I've also had the issue where the printer pulls two sheets, so figure that out too.

thanks got it