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.