Thread: [Solved] Macro for printer properties
View Single Post
 
Old 07-18-2011, 05:32 AM
kjk20 kjk20 is offline Windows XP Office 2007
Novice
 
Join Date: Jul 2011
Posts: 4
kjk20 is on a distinguished road
Smile

Quote:
Originally Posted by macropod View Post
Hi kjk20,

What is a 'D' size drawing and what has this to do with the printer properties?
Hey Macropod,
A D-Size drawing is just a different size drawing.
Here are the other types:
ANSI A 215.9 x 279.4 8.5 x 11 ANSI B 279.4 x 431.8 11 x 17 ANSI C 431.8 x 558.8 17 x 22 ANSI D 558.8 x 863.6 22 x 34 ANSI E 863.6 x 1117.6 34 x 44
I have a report in access that I want in ANSI D but Access won't allow a page width to be greater than 22"
I figured a solution around this problem would be to export that report into word and print through word in ANSI D.
My problem is that I was wondering if i could create a macro to automatically do the configurations instead of having to always change printer properties every time i export into word.

Thanks for any help!
Reply With Quote