Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sizing form (A2002)

    I've inherited a pop up form and regardless of how I size it in design view in form view it remains the same size. I can resize the header and footer to take up different proportions of the space but not the overall form size. The auto resize and auto center are both set to yes. Adjusting the width property doesn't make any different either, nor does changing Grid X or Y. There is no code behind the form sizing it. nor in a database module. The size to fit command stays greyed out in form view. The min/max is set to enabled but there is no min/max buttons at the top right of the form. Anyone out there who can tell me where should I be looking to find out how the size is set?

    eli

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

    Re: sizing form (A2002)

    If you open the form in design view, what are the settings for the following properties?
    - Border Style (in the Format tab)
    - Popup (in the Other tab)
    - Modal (in the Other tab)

  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sizing form (A2002)

    Border: Dialog
    Popup: Yes
    Modal: No

    Soon as I changed Dialog to sizable, I was in business. Hey!!

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

    Re: sizing form (A2002)

    That's why I asked <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sizing form (A2002)

    Eli

    Heres a little utility written by Hans some time ago.
    Its called "frmMoveSize"

    There was an updated version which dealt with Twips, cm's etc but I can't find it now.

    Import form "frmMoveSize" and there's a module also.
    Open the form you want to get sizes of and open frmMoveSize.
    In the combo, select your form (The one you want sizing) and you'll see all the form sizes and positions.

    From there, you can use the Movesize command on the On_Open event ie:

    <pre>Private Sub Form_Open(Cancel As Integer)
    DoCmd.MoveSize Right:=5955, Down:=1650, Width:=5925, Height:=6000
    End Sub</pre>


    This only answers part of your post, but I'm sure Hans will help you further.
    I find this utility very useful.
    Attached Files Attached Files

Posting Permissions

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