Setting printer properties in Vba

I have an Access application that prints pdf files by using the command line switches for adobe reader.  This works fine except that when I change the papersize for a printer using the printer object:
 
     Application.Printer.PaperSize = acPRPS11x17)

and then print the drawing using Adobe reader:

     c:\program files (x86)\adobe\reader9.0\reader\acrord32.exe /t <drawingpath>

it does not use the new paper size settings.
Is this because I am calling an application outside of Access?
dsoderstromAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jjafferrConnect With a Mentor Commented:
I searched, and all I got was:
the command line does not support selection of paper format or other advanced options.

However, The following switches are available:
/t <filename> <printername> <drivername> <portname> - Print the file the specified printer.

so what I assume you can do is, copy the adobe pdf printer to another name, change the paper size, and save it.
Then you can call this printer for your specific paper size.

jaffer
0
 
pdebaetsConnect With a Mentor Commented:
Well, you are saying Application.Printer.Papersize =

Then when you print, you are running a different application - "acrord32.exe"
0
 
dsoderstromAuthor Commented:
solutons presented did not solve the problem but need to close the question
0
All Courses

From novice to tech pro — start learning today.