Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520

    Unanswered: Resize Report Preview Popup Window

    I'm trying to get a report preview popup window to resize so it is 6.5 inches wide (9360 twips) and 8.5 inches high (12240 twips). I'm using Docmd.MoveSize 500, 500, 9360, 12240. The top and Left (the 500s) work, but the Width and Height (9360 and 12240) don't. The report preview popup window is sized at about 1440 x 1440.

    Another constraint is that the Access window is minimized, and only one form is showing because it is a popup also. When I Restore the Access window, the report preview popup window sizes correctly.

    Overall, what I'm trying to do is to write an application that only uses Popup windows, therefore keeping the Access window minimized, and out of the way.

    Any ideas how I can get the report preview popup window to resize?

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I did this but it may not be exactly what you're looking for....

    CommandBars("PKPrintMenu").Controls("Zoom").Execut e

    Where PKPrintMenu was a customized menu I made (ie. Menu Bar line for the property of the report) to show for reports where the PKPrintMenu had the Zoom control in it.

    Good choice on the popups Vic. I use them all the time. I also set the modal to true so they don't click off of the popup and it remains open in the background. For previewing a report, I then set the form to visible = false and then restore it when the report closes (otherwise with the modal set to true, the entire MSAccess application "freezes" and you have to kill it via the task manager.) Try setting the modal of the form to true and then open a report via a button on that form and you'll see what I mean.
    Last edited by pkstormy; 08-02-07 at 14:59.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Does
    Code:
    DoCmd.RunCommand acCmdZoom10
    Come close to what you want?
    Note that there are a handful of other sizes and similar commands too
    George
    Home | Blog

  4. #4
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Thanks George. That has helped me.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Orr..
    Perhaps the answer lies in how you open it (yes I know it won't be a perfect size, but hey, it may be popup-er-ific!
    Code:
    DoCmd.OpenReport "report1", acViewPreview, , , acDialog
    'Or
    DoCmd.OpenReport "report1", acViewPreview, , , acWindowNormal
    George
    Home | Blog

Posting Permissions

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