Access 2010 Print PDF from file - Shrink A3 to A4
Posted on 2012-03-25
I have a print option the prints a job sheet from access and then prints a list of files listed on the job. I have used the Shell Execute to print these if they are PDF's:-
Call ShellExecute(Application.hWndAccessApp, "print", strfilepath, "", "", 0)
This all works fine however some of the files are in A3 format and only have A4 in the tray so only prints part of the page.
If you open the PDF and print (Ctrl P) and you choose Fit to Printable area or Shrink oversized pages they print on A4 OK. (Obviously smaller size but this is OK)
Is there any way I can pass this print property to the printer so A3 prints on A4 paper?.