Printing report in landscape & legal size

[skp]

Hello, I'm having a problem with printing a report. I set the report to print in landscape but all the columns arent fitting on the page so I changed the page setup from design view to legal size paper but for some reason the last column is not printing even on legal size. I would be fine even if the last column printed on the second page by itself but its not even doing that it just cuts it off and when it prints its only printing one page and the report is multiple pages long.

The users will be printing from database view not design view, I have a print button on the reports page that is working fine the only issue is that the report is only printing the 1st page and the last column is not printing at all as mentioned before.

Is there a way using VBA that when the print button is hit from database view that will open a print dialog box or print preview so the options of number of pages and paper size can be chosen?

Here is the basic code I have set on the print button, everything I have tired has failed:

Private Sub cmdPrint_Click()
Forms("frmReports").Printer.Orientation = acPRORLandscape
DoCmd.PrintOut , 1, 1, acLow, 1, False
End Sub

 

[PaulO]

If you haven't already adjusted the Print Margins in Page Setup, then try that as a starter.

Otherwise, you'll simply have to reduce the overall width of your report by any combination of:-
a) choosing a smaller and/or thinner (e.g. Arial Narrow) font
b) reducing each field width
c) reducing any blank spaces between fields

 

[Trevor G]

You have created several threads with the same question, please stick to the forum rules.

As a point you state you want to print a report when you are actually looking at printing a Form !

If you want it to print as a report, select design view of the form and then select all controls and copy them, then create a report and paste them in the data section, then adjust as necessary to fit to the paper size etc.

Your code should then look to print to the Report rather than the form.