Orientation and Font Size Change When Printing a Report

[ed coleman]

I have created a report in landscape that appears nicely on the screen (see upper image on the attached file). However, when I go to print preview, it has HUGE print and now appears to be a portrait orientation (see bottom image on the attached file).

Any assistance would be much appreciated.

Regards,
Ed

 

[JHB]

How do you do the Print Preview, from the Ribbon or how?
How does the report looks like in design view?
Could it be that you've set the zoom to more as 100%?
Else post a database with the report in it, and some sample data.

 

[ed coleman]

I have uploaded the design view of the report. I am using a remote connection so I basically cannot test the print myself so I use the print preview in Access. The user verifies that the printout looks like the file that I originally attached.
I am using DoCmd.PrintOut acPrintAll to print the report from a control button.

 

[Minty]

That looks like you have dumped the form directly into the report, why else would it have the print button in it, or you are printing the form not the report.

You should be opening the report directly to either print preview or print directly.

DoCmd.OpenReport "YourReportName", acViewPreview

 

[ed coleman]

Hi Minty,
The report is in report view format so they can view it, download to Excel or Print it (hopefully). I have changed the code to what you suggested but used acNormal rather than the preview.

Have to wait until the user gets back to me to see if it works.

Regards Ed

 

[Minty]

I think your command would print the active object - which would probably be the form the button was on - not the report.

 

[ed coleman]

Haven't heard back from my user yet. Maybe she's hopping the wag to get a long weekend.

Regards Ed