Connecting Tech Pros Worldwide Forums | Help | Site Map

zoom access report automatically

Newbie
 
Join Date: Jun 2009
Posts: 12
#1: Jul 1 '09
Hi,
I'm using access 2003. Is there a way for me to open an access report with zoom to 82% automatically? Right now, I set it up as maximize, using
Expand|Select|Wrap|Line Numbers
  1.  docmd.maximize 
but I want it to zoom to 82% for users to be able to see all the data clearly when they open the report.
Please help.

Thank you in advance.

ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,218
#2: Jul 1 '09

re: zoom access report automatically


Quote:

Originally Posted by Bay0519 View Post

Hi,
I'm using access 2003. Is there a way for me to open an access report with zoom to 82% automatically? Right now, I set it up as maximize, using

Expand|Select|Wrap|Line Numbers
  1.  docmd.maximize 
but I want it to zoom to 82% for users to be able to see all the data clearly when they open the report.
Please help.

Thank you in advance.

Is 75% close enough?
  1. In the Open() Event of your Report, place the following code:
    Expand|Select|Wrap|Line Numbers
    1. Private Sub Report_Open(Cancel As Integer)
    2.   DoCmd.Maximize
    3. End Sub
  2. To Zoom the Invoice Report to 75%:
    Expand|Select|Wrap|Line Numbers
    1. DoCmd.OpenReport "Invoice", acViewPreview
    2. DoCmd.RunCommand acCmdZoom75
Newbie
 
Join Date: Jun 2009
Posts: 12
#3: Jul 1 '09

re: zoom access report automatically


Thanks, That's what I need. I was wondering what can be the code for zoom. Thank you again...
ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,218
#4: Jul 1 '09

re: zoom access report automatically


Quote:

Originally Posted by Bay0519 View Post

Thanks, That's what I need. I was wondering what can be the code for zoom. Thank you again...

You are quite welcome.
Reply


Similar Microsoft Access / VBA bytes