Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Dec 2001
    Location
    Lost Wages, NV
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    acViewPreview (Acess2000-VBA)

    Another novice question from the dinosaur:

    I would like to know how to have a report in acViewPreview mode open in the magnified view. My client does not want to have to use the mouse to click on the preview to get the image magnified.

    TIA
    ElDinosaurio
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Star Lounger
    Join Date
    Nov 2001
    Posts
    75
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: acViewPreview (Acess2000-VBA)

    DoCmd.OpenReport "ReportName", acPreview
    DoCmd.RunCommand acCmdZoom150

    When you put in the RunCommand you can choose your magnifcation....

    hth,
    Jack

  3. #3
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: acViewPreview (Acess2000-VBA)

    What Jack has replied will work as long as you use one of the allowable specified Zoom levels.

    If you want to set the Zoom level to a custom percentage then you can use the following function:

    <font color=448800>' This function allows Report Custom Zoom level from 0% to 2500%</font color=448800>
    Function PreviewAndZoomReport(ReportName As String, ZoomCoeff As Integer)
    On Error GoTo Err_PreviewAndZoomReport

    If Not (ZoomCoeff >= 0 And ZoomCoeff <= 2500) Then
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

  4. #4
    New Lounger
    Join Date
    Dec 2001
    Location
    Lost Wages, NV
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: acViewPreview (Acess2000-VBA)

    Jack,

    Thanks, I will try this this morning. I only want it to open at 100% so this should work well for me

    ElD.

  5. #5
    New Lounger
    Join Date
    Dec 2001
    Location
    Lost Wages, NV
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: acViewPreview (Acess2000-VBA)

    Ricky,

    Thanks for the code. I will try Jack's first as I only need a simple fix, but I am keeping your function for future use.

    Thanks again

    ElD-

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •