Orientation and Font Size Change When Printing a Report (1 Viewer)

E

ed coleman

Registered User.

Local time

Yesterday, 22:27

Joined

Nov 8, 2012

Messages

44

• Jul 27, 2017

• #1

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

 

Last edited: Apr 16, 2019

J

JHB

Have been here a while

Local time

Today, 07:27

Joined

Jun 17, 2012

Messages

7,732

• Jul 28, 2017

• #2

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.

 

E

ed coleman

Registered User.

Local time

Yesterday, 22:27

Joined

Nov 8, 2012

Messages

44

• Jul 28, 2017

• #3

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.

 

Last edited: Apr 16, 2019

Minty

AWF VIP

Local time

Today, 06:27

Joined

Jul 26, 2013

Messages

10,366

• Jul 28, 2017

• #4

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.

Code:Copy to clipboard

DoCmd.OpenReport "YourReportName", acViewPreview

 

E

ed coleman

Registered User.

Local time

Yesterday, 22:27

Joined

Nov 8, 2012

Messages

44

• Jul 28, 2017

• #5

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

AWF VIP

Local time

Today, 06:27

Joined

Jul 26, 2013

Messages

10,366

• Jul 28, 2017

• #6

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

 

E

ed coleman

Registered User.

Local time

Yesterday, 22:27

Joined

Nov 8, 2012

Messages

44

• Jul 28, 2017

• #7

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

Regards Ed