469,644 Members | 1,774 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,644 developers. It's quick & easy.

zoom access report automatically

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.
Jun 30 '09 #1
3 7356
8,800 Expert 8TB
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
Jul 1 '09 #2
Thanks, That's what I need. I was wondering what can be the code for zoom. Thank you again...
Jul 1 '09 #3
8,800 Expert 8TB
You are quite welcome.
Jul 1 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Elle Short via .NET 247 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.