Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Force form to load standard size (not maximized) (A2k)

    I have a few forms that I'd like to force the form size, (so when a user closes a datasheet form that they had maximized, they're not stuck looking at a maximized form that only takes up 2"x4" of the screen...)

    Is there a property to set for this?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Force form to load standard size (not maximized) (A2k)

    You could put the line

    DoCmd.Restore

    in the On Activate event of the forms.

    (You could set the Popup property of the forms to Yes, since popup forms come up non-maximized by default, but that might have unexpected/undesired side effects: popup forms float in front of all other Access windows and aren't bound to the Access application window.)

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Force form to load standard size (not maximized) (A2k)

    Thanks Hans, that works great.

    Also - thanks for the additional info with popup forms <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  4. #4
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Force form to load standard size (not maximized) (A2k)

    If you want to stop your user from resizing a form that you have set up, put the following code in the form's Resize event.

    DoCmd.RunCommand acCmdSizeToFitForm
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Force form to load standard size (not maximized) (A2k)

    I leave all the forms borders set as thin, so they can't anyways <img src=/S/wink.gif border=0 alt=wink width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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