Results 1 to 6 of 6

Form size ???

  1. #1
    ksor's Avatar
    ksor is online now Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Posts
    119

    Form size ???

    I know I can set height/width and so, but I just want the size to fit the space for HEADER + DETAILSECTION + FOOTER !

    Now it's more by chance that I get the right size of the form and I'm so sick and tired of this malfunction - it has never work for me !



    How are "best practice" here ?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,697
    Can't you just maximize it and let user have all the space?

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,436
    Is the form in Single Form view or Continuous Forms view?

    You are NOT trying to print the form, are you?


    Can you post an image of what you mean?
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  4. #4
    ksor's Avatar
    ksor is online now Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2017
    Posts
    119
    Oh, some one answered - why wasn't I noticed by E-mail ?

    Anyway THX for the answer ....

    I like my forms to ONLY be so big they can "frame" the HEADER+DETAIL+FOOTER and autamically make space for the vertival scrollbar -if needed.

    I think I remember 10-20 years back that some special practice when saving could do that - but I forgot it !

    Today I can't get my forms to present "nicely" on screen ... they are too big or small ... seldom "right on the money" (=HEADER+DETAIL+FOOTER + scrollbar)

  5. #5
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,723
    Change the settings in Access options from Tabbed documents to Overlapping Windows.
    Save the form the size you want and it will reopen at that size.
    If you have issues with different monitor size or different resolutions, use automatic form resizing
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  6. #6
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,436
    You are using Single Form mode? If you put "DoCmd.Maximize" in the form load event, the form will fill the screen. Using "DoCmd.Maximize" affects all forms that are open, so you should use "DoCmd.Restore" to return the forms back to the default size.
    Of course, this only works if you are NOT using tabbed documents - they are always maximized.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Replies: 12
    Last Post: 10-21-2018, 05:49 PM
  2. Size of Access Window set to Fom size
    By MrDummy in forum Access
    Replies: 2
    Last Post: 06-26-2016, 05:18 AM
  3. Replies: 4
    Last Post: 02-10-2015, 01:07 AM
  4. Replies: 2
    Last Post: 03-20-2013, 04:25 PM
  5. Replies: 3
    Last Post: 07-19-2012, 09:27 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
  •  
Tech Forums: Microsoft Office Forums