Printing a report (1 Viewer)

[rmlim83]

Hi everyone. I am currently using MS Access 2007 to create a form. When a run a report from that form, the print preview shows that my report is spread out over dozens of sheets. I just want to print the report as it appears on the report view.
Thanks!

 

[LGordon]

It would appear that you can only print the width of the paper you are using. If your report is wider, then it continues on a second page.

Could some of the more experienced Access developers confirm this statement? Also, is there a way to replicate the Excel format to Fit to Page setting.