Macro for printer properties

macropod · #1 07-18-2011, 06:26 AM

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.

kjk20 · #2 07-18-2011, 06:30 AM

Quote:

Originally Posted by macropod

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with Document Properties Prompt Macro	KJJ	Word VBA	14	11-10-2016 08:18 PM
Word file properties	Sashikala	Word	0	04-19-2010 11:24 PM
Macro to put content into keywords properties?	erik2000	Word VBA	3	03-05-2010 10:14 PM
document properties issues	charris1980	Word	0	04-29-2009 12:49 PM
Looping though Custom Properties in VBA	suekay	Misc	0	05-19-2006 06:10 AM