How to Change Page Print Size From Legal to A4???

[NoDBExperience]

Does anybody know how or if at all possible to change the print size of a document from Legal to A4???

Currently i am adopting a rather laborious method by going back into the PC and changing the printer settings back and forth...

Unless i reformat the ENTIRE document, is there an easier method one can adopt through programming codes>>??
The reports are from MS Access???

Thanks in advance..

RAJ

[ADezii]

Does anybody know how or if at all possible to change the print size of a document from Legal to A4???

Currently i am adopting a rather laborious method by going back into the PC and changing the printer settings back and forth...

Unless i reformat the ENTIRE document, is there an easier method one can adopt through programming codes>>??
The reports are from MS Access???

Thanks in advance..

RAJ

You would modify the PaperSize Member of the PrtDevMode property for the specific Report. The PrtDevMode property setting is a 94-byte structure that mirrors the DEVMODE structure defined in Windows. It is a rather daunting task to say the least. Reference the PrtDevMode Property for complete information. Available Paper Sizes are:

Value   Paper size 
1       Letter (8.5 x 11 in.) 
2       Letter Small (8.5 x 11 in.) 
3       Tabloid (11 x 17 in.) 
4       Ledger (17 x 11 in.) 
5       Legal (8.5 x 14 in.) 
6       Statement (5.5 x 8.5 in.) 
7       Executive (7.25 x 10.5 in.) 
8       A3 (297 x 420 mm) 
9       A4 (210 x 297 mm) 
10      A4 Small (210 x 297 mm) 
11      A5 (148 x 210 mm) 
12      B4 (250 x 354 mm) 
13      B5 (182 x 257 mm) 
14      Folio (8.5 x 13 in.) 
15      Quarto (215 x 275 mm) 
16      11 x 17 in. 
18      Note (8.5 x 11 in.) 
19      Envelope #9 (3.875 x 8.875 in.) 
20      Envelope #10 (4.125 x 9.5 in.) 
21      Envelope #11 (4.5 x 10.375 in.) 
22      Envelope #12 (4.25 x 11 in.) 
23      Envelope #14 (5 x 11.5 in.) 
24      C size sheet (17 x 22 in.) 
25      D size sheet (22 x 34 in.) 
26      E size sheet (34 x 44 in.) 
27      Envelope DL (110 x 220 mm) 
28      Envelope C5 (162 x 229 mm) 
29      Envelope C3 (324 x 458 mm) 
30      Envelope C4 (229 x 324 mm) 
31      Envelope C6 (114 x 162 mm) 
32      Envelope C65 (114 x 229 mm) 
33      Envelope B4 (250 x 353 mm) 
34      Envelope B5 (176 x 250 mm 
35      Envelope B6 (176 x 125 mm) 
36      Envelope (110 x 230 mm) 
37      Envelope Monarch (3.875 x 7.5 in.) 
38      6-3/4 Envelope (3.625 x 6.5 in.) 
39      US Std Fanfold (14.875 x 11 in.) 
40      German Std Fanfold (8.5 x 12 in.) 
41      German Legal Fanfold (8.5 x 13 in.) 
256     User-defined 

To modify the PrtDevMode Property of your Report via a User Interface (highly recommended):
__1. Open Report in Design View
__2. File ==> Page Setup ==> Page Tab
__3. Select Use Specific Printer Option ==> Printer Button
__4. On the Printer's Page Setup Dialog Box ==> Properties
__5. Paper Tab ==> Paper Size