Report to PDF

[NDD]

Access 2010
Acrobat X Standard

I have reports on both 11X17 and 8.5 by 11.

When I convert the 11 X 17 to Acrobat, it changes the paper size to 8.5 X 11 on both the PDF and the print view of the report in access.

If I set Acrobat to 11 X 17, it still does it.

I'd appreciate some help if anybody knows what I'm doing wrong.

 

[BlueIshDan]

I believe the print command allows you to describe the paper size. So try using a PDF Print driver, print to it using VBA and describe the paper sizes to what you want them to be.

 

[NDD]

Thanks Dan,
I'll look into it. I made need more instruction. I'm not very conversant in VBA yet. I'm learning, but it's a process.

 

[BlueIshDan]

What version of access are you working with?

 

[BlueIshDan]

Pushed together an example of something that may work for you

Private Sub Button_Click()
    Dim objPrinter As Printer
    Set objPrinter = Application.Printers("Adobe PDF Printer")
    
    ' Set settings here:
    objPrinter.PaperSize = acPRPS11x17
    
    Set Application.Printer = objPrinter
    
    'If report is not yet open:
    DoCmd.OpenReport "MyReport", acViewNormal
    
    DoCmd.PrintOut
    
End Sub

 

[NDD]

2010.

Thanks

 

[NDD]

Dan,
I pasted it in on a button and got:

Run Time Error '5'
Invalid Procedure Call or Argument



Set objPrinter = Application.Printers("Adobe PDF Printer")

Highlighted in the debugger

 

[BlueIshDan]

You need to install the Adobe PDF Printer (print driver)

 

[BlueIshDan]

Here's one: PDF Print Driver

 

[BlueIshDan]

If you wish to go legit I suggest the CutePDF driver.