how do I force a report page to print over 2 pages in Access?

[TCoop]

I have a report that I want to print over both sides of an A3 sheet of paper
but the detail section won't go that wide. The report is for a sign-out book
and the fields have to be wide enough to put handwritten detail in. I
wondered if it was possible to set the paper size to A2 and then print to A3,
but A2 is not an allowed paper size (as far as I can see). I'm using Access
2007.

 

[Humar]

Dear TCoop, did you already try to print it with the help of PFD?
You can download Primo PDF 4.0.2. free from website www.download.com Choose
in the dialog box instead of one of the printers: ‘PrimoPD’ to get the report
as a PDF-file which, I hope, you can print in the way you prefer.--
Humar Holland

 

[TCoop]

Thanks Humar, I've got a PDF program, but what I can't do is get the pages
wide enough to flow over to both sides of the A3 page. In Design View I can
only make the page 56cm wide and this won't allow me to make the most of the
space on the back of the page. I need to pull the page out to be 84cm wide.

 

[John Spencer]

Access allows a MAXIMUM width of approx 56 centimeters (22 inches). So if you
need a greater width than that, you will have to find a way to export the
information to a program that will support the larger width.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County