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?
 
jjafferrCommented:
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
 
pdebaetsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.