How to open report with 100% zoom (1 Viewer)

SachAccess

Active member
Local time
Today, 14:33
Joined
Nov 22, 2021
Messages
389
Hi,
I have few reports in my existing MS Access file. Whenever I open the report, it gets opened in 55% or 65% zoom.
How do I set default 100% zoom for the report. Can anyone please help me in this.
 

GinaWhipp

AWF VIP
Local time
Today, 05:03
Joined
Jun 21, 2011
Messages
5,899
Try the below after the Report Open line...
Code:
DoCmd.RunCommand acCmdZoom100
 

SachAccess

Active member
Local time
Today, 14:33
Joined
Nov 22, 2021
Messages
389
Try the below after the Report Open line...
Code:
DoCmd.RunCommand acCmdZoom100
Thanks for the help @GinaWhipp . Have a nice day ahead. :)
PS - Am getting a bug with this line. I am trying on Google too. Will share further updates. Thanks.

Private Sub Report_Load()
DoCmd.RunCommand acCmdZoom100
End Sub

The command or action zoom100% is not available now.
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 17:03
Joined
May 7, 2009
Messages
19,246
make sure these 3 are set to Yes.
Screenshot_2.png
 

GinaWhipp

AWF VIP
Local time
Today, 05:03
Joined
Jun 21, 2011
Messages
5,899
Thanks for the help @GinaWhipp . Have a nice day ahead. :)
PS - Am getting a bug with this line. I am trying on Google too. Will share further updates. Thanks.

Private Sub Report_Load()
DoCmd.RunCommand acCmdZoom100
End Sub

The command or action zoom100% is not available now.
I said to put that under the line that opens the report not on the report Load event.
 

Users who are viewing this thread

Top Bottom