An access Problem : how to show a access report in A3 size and landscape mode
I have created a Form in Access 2010,in which there is a PDF button. When I click on that button it shows a report in PDF format.
I have this code for that
Private Sub cmdPrintReportPDF_Click()
If Form_Graphs.tab_graph.Value = 2 Then
DoCmd.OpenReport "Graph_report2", acViewReport
DoCmd.OutputTo acOutputReport, "Graph_report2", ".pdf", "C:\Graph_report2.pdf", True
'DoCmd.Close acReport, "Graph_report2"
Else
DoCmd.OpenReport "Graph_report", acViewReport
DoCmd.OutputTo acOutputReport, "Grap开发者_Go百科h_report", "pdf", "C:\Graph_report2.pdf", True
'DoCmd.Close acReport, "Graph_report"
End If
End
Now when the PDF is open its content is split into two pages. I want to set the page size and page layout of this PDF through VBA code. I have set the size and layout of report in the print preview but it works for only my computer, it doesn't work on other computers.
So what I want is to set the size and layout of the report through VBA code.
精彩评论