Results 1 to 10 of 10
  1. #1
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Full-size Preview? (AXP 10.2627.2625)

    Is there an argument to OpenReport (or perhaps some other function) that would allow me to specify that a report opened in 'preview' would display at full size, rather than 'full page' view?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Full-size Preview? (AXP 10.2627.2625)

    In the On Open Event of the report :
    DoCmd.Maximize
    Francois

  3. #3
    Star Lounger
    Join Date
    Dec 2001
    Location
    Fredensborg, Denmark
    Posts
    86
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Full-size Preview? (AXP 10.2627.2625)

    You may want to place the DoCmd.Maximize stmt right after your DoCmd.OpenReport. Then you don't have to put code in the report.

  4. #4
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Full-size Preview? (AXP 10.2627.2625)

    Merci!

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Full-size Preview? (AXP 10.2627.2625)

    Thanks!

  6. #6
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Full-size Preview? (AXP 10.2627.2625)

    Maximize enlarges the entire window.

    What I _really_ want is the same size window, but full size display _in_ that window. As if I had applied the zoom mouse-pointer.

  7. #7
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Full-size Preview? (AXP 10.2627.2625)

    Include the following line after your DoCmd.OpenReport statement:

    <font face="Georgia">DoCmd.RunCommand acCmdZoom100
    </font face=georgia>
    Note that this will not work if you try to include it in your On Open event for the report. Docmd.Maximize does work either place... go figure.

  8. #8
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Full-size Preview? (AXP 10.2627.2625)

    Thanks Tom, but I was too cocky, thinking I knew where these commands go

    The CmdButton on my form runs a macro that displays the PrintPreview for the report.

    Where do i write the two statements to execute sequentially so that the form is zoomed? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  9. #9
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Full-size Preview? (AXP 10.2627.2625)

    Peter,

    If you're using a macro for the On Click event for your Preview Report button on your form, then you just need to add a second action to that macro (after your OpenReport action). Select RunCommand as the action and Zoom100% as the command (it's in the command drop-down list).

    Alternatively, if you're using VBA code (by selecting "Event Procedure") as the On Click event handler, then include the following code for your cmdButton_Click() procedure:

    <font face="Georgia">DoCmd.OpenReport "ReportName", acViewPreview
    DoCmd.RunCommand acCmdZoom100</font face=georgia>

    Hope this helps. Holler if you need more detail.

  10. #10
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Full-size Preview? (AXP 10.2627.2625)

    Thanks -

    I got it to work by using the event procedure, and will probably stick with that in the future.

Posting Permissions

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