Form prints two extra pages.

[OBBurton]

Hi,

I have a form that looks and prints exactly as I want it to, except for two little things. These things are extra pages. They don't appear on the print preview, but they always show up on the printer and on the pdf file when I email it. One page is blank and the last page has "Page 1 of 1" at the bottom right corner of the page. If it helps, I would be happy with always limiting the printing to one page.

I'm stumped, but its probably some simple thing I have done building the form or something.

 

[pbaldy]

Most of us would recommend not trying to print a form. Use a report; you have much more control over the format and layout.

 

[JHB]

When does the blank page appear, (as second page or ...)?
Have you tried to change the page margin?
How do you print it out, from code or?
I agree with pbaldy, reports is the best choice!

 

[OBBurton]

I can't believe I did that! I'm not trying to print a form, I'm trying to print a report! I am such a knucklehead! Should I close this thread and open a different one?

 

[OBBurton]

To answer JHB's questions, the pages appear as a second and third page on the printer or PDF file. I haven't made any attempt to control the page margins or any printer settings at all, neither manually or with code. The code I use to call for the printer is:

DoCmd.OpenReport "rptInvoice", acViewNormal

 

[pbaldy]

And check that the width of the report in design view plus the side margins doesn't exceed your paper width. Make sure to drag the right margin to the left as far as it will go.

 

[OBBurton]

Hi, Thanks to JHB, pbaldy and AccessBlaster for the suggestions!
I Found It! Somehow a page footer text box containing "="Page " & [Page] & " of " & [Pages]" was way over on the 21 inch position of the Page Footer!

 

[pbaldy]

Glad you got it sorted out!