Connecting Tech Pros Worldwide Help | Site Map

zoom access report automatically

  #1  
Old July 1st, 2009, 12:26 AM
Newbie
 
Join Date: Jun 2009
Posts: 11
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.
  #2  
Old July 1st, 2009, 02:17 AM
ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,168
Provided Answers: 20

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
  #3  
Old July 1st, 2009, 04:24 PM
Newbie
 
Join Date: Jun 2009
Posts: 11

re: zoom access report automatically


Thanks, That's what I need. I was wondering what can be the code for zoom. Thank you again...
  #4  
Old July 1st, 2009, 04:57 PM
ADezii's Avatar
Expert
 
Join Date: Apr 2006
Location: Philadelphia
Posts: 5,168
Provided Answers: 20

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 Threads
Thread Thread Starter Forum Replies Last Post
Dr. Dobb's Python-URL! - weekly Python news and links (Dec 2) Cameron Laird answers 97 December 8th, 2005 08:25 PM
open source windandwaves answers 3 November 13th, 2005 12:14 PM
Access 2002 Performance Issues John answers 20 November 12th, 2005 02:55 PM