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

Quote:
Originally Posted by macropod View Post
Hi kjk20,

Like Access, Word has a maximum page size of 22in in either direction. So exporting to Word won't advance your project.

FWIW, the 22in limitation is due to the fact that 22in represents 31,680 twips (20 twips = 1pt & 72pt = 1in), the largest number of whole-inch twips below 2^15 (32678).

Of course, if you output your report to a PDF, scaled appropriately, you should be able to re-scale the PDF at print time to suit whatever size paper is available.

Thats a bummer macropod but thanks for letting me know.
I've been fiddling with Macros all morning to get it to do what I want.
Do you know if its possible to set up a macro to do a similar thing in PDF format?
Reply With Quote