Results 1 to 3 of 3
  1. #1
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    862

    Popup sizing

    I am trying to set Access App minimized on form load, then have the main for as a POPup.

    I am using:



    Private Sub Form_Load()
    DoCmd.RunCommand acCmdAppMinimize
    End Sub

    This makes Access minimize on the taskbar and the main form pop up in a normal size.

    When I select a command button to open a report I get a bar with the name on it. Such as:

    Click image for larger version. 

Name:	POP - Bar.jpg 
Views:	19 
Size:	25.7 KB 
ID:	22080

    If I go to the report in design mode then save (nothing has changed) the report sizes as normal, even if I close it and reopen it. When I close Access and restart, it goes back to the bar mode.

    I can select and drag it open to the size I want, but that defeats the purpose. I can put docmd.maximize, but that defeats what I am trying to do.


    Properties:
    Click image for larger version. 

Name:	POP info.png 
Views:	18 
Size:	18.2 KB 
ID:	22081

    Thanks

    Wayne

  2. #2
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    862
    Additional Information:
    Pop up forms open correctly, only the reports seem to be minimized (Flattemed). I can resize them manually.

  3. #3
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    862
    Figured it out, but if there is an easier way, please feel free to provide input.

    VBA:
    Private Sub Report_Activate()
    DoCmd.MoveSize , , , 20000
    End Sub

    In report properties:
    Popup=Yes
    Autocenter=Yes
    Autosize=No

Please reply to this thread with any new information or opinions.

Similar Threads

  1. sizing
    By slimjen in forum Forms
    Replies: 7
    Last Post: 06-07-2014, 04:48 PM
  2. groupheader sizing
    By RayMilhon in forum Reports
    Replies: 9
    Last Post: 09-25-2012, 11:32 AM
  3. Sizing of a report
    By ETCallHome in forum Reports
    Replies: 7
    Last Post: 06-25-2011, 10:51 PM
  4. Sizing and positioning
    By 161 in forum Database Design
    Replies: 1
    Last Post: 04-09-2011, 10:52 AM
  5. Pictures sizing
    By newtoAccess in forum Access
    Replies: 0
    Last Post: 11-22-2009, 10:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums