Report Formatting

[MICHELE]

I have made a report with a lot of formatting: 6 columns, different margins, legal paper, etc. I also have my database secured. When I setup the icon on my users' computers the formatting doesn't work right. Mainly, the paper won't automatically go to Legal.
I wish I could print this in another program that would be much easier to see. Right now they use Excel which is easier to view, but much more time consuming. Does anyone have any suggestions? We're trying to get it to look like a calendar.

 

[Scott_S]

On the Page tab in the Page Setup screen while in design view of a report, selct the Use Specific Printer option and then selct the Printer button. This should let you select the Printer and Tray etc that you want the report to go to. If your printing to different printers selct the Page Setup option again while in design view and on the page tab make sure it is set to the paper size you want. It will prompt users for this paper if this is not the default paper size on the printer.