Printing issue in MS Access 2007

I built a report in Access that is too wide for the standard copy paper (even after adjusting the margins to 0'. and reformatting the actual report itself). Basically, I am looking for a "shrink to fit" option, but it doesn't appear to exist.

Is there a way to make my report fit onto one page without export开发者_如何学编程ing the document to another format? Or will I actually have to purchase some bigger paper?

Thanks

---

Such an option does not exist. Butwhat about printing to PDF ? I think Acrobat has an option to automatically rotate and adjust to your paper.

---

Does the option exist to reduce the size of all the elements so that the report does fit on one page normally? I mean, reduce the font size, reduce the field sizes; but not to the point that either the text is unreadable - or the fields start cutting your output off?

Sometimes the best way is to format the report around the idea that you will need to print it off on a normal sheet of paper first, then expand it from there if you find you have too much white space.

Just my $0.02 though, your mileage may vary.