Snapshot VIEWER - Letter or Legal size default

[Bill]

Hi,

Is there a way to create a code for exporting Snapshot Format either Letter
or Legal size on Landscape.

I' m having a problem when exporting Legal size on Landscape to Snapshot
View. When I open the file and it show letter size on landscape. Is there
a way to create a code for exporting a report that has legal size on
landscape into Snapshot View default than showing Letter size on landscape.
I see a report in half.

Your help would be much appreciated. Thanks

 

[Yuan Shao]

Hello Bill,

I would appreciate your patience while I am looking into this issue. I will
post my response at soon as I have update for you.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Yuan Shao]

Dear Bill,

I learned you want to create a code for exporting a report that has legal
size on landscape into snapshot view. Please try to use the following codes
to see if it meets your requirements.

Dim rpt As Access.Report

DoCmd.OpenReport "Alphabetical List of Products", acPreview
Set rpt = Reports("Alphabetical List of Products")

'Set the default printer's orientation to landscape
rpt.Printer.Orientation = acPRORLandscape

'Set the default printer's paper size to legal
rpt.Printer.PaperSize = acPRPSLegal

DoCmd.OutputTo acReport, "Alphabetical List of Products",
"SnapshotFormat(*.snp)", ""

I also found the following article for your reference.

290293 Printer Properties Not Inherited by Objects That Use the Default
Printer
http://support.microsoft.com/?id=290293

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Yuan Shao]

Hi Bill,

How is the issue going on your side? Let us know if you need further
assistance on this issue.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.