Results 1 to 8 of 8
  1. #1
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    479

    Form design

    When designing a Form I find setting width and height a right pain.


    I can use MoveSize but trial and error finding the parameters is necessary
    I find it can be dragged in design mode and closed. Then it opens correctly the next timer - but do any more designing and that is all gone.


    Is it possible to make that size stick?


    Alternately, can the size and position dragged to be known, so it might be entered into the MoveSize instruction?


    The Form is unbound with PopUp set yes. No scrollbars, Nav or record selectors.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,930
    Just closing the form won’t save its position, you need to save it as well

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2019
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,740
    Trial and error, trial and error. It can be especially daunting on a main form with a tab control containing subforms. Those scroll bars just keep showing up...

  4. #4
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    I have an example app https://isladogs.co.uk/move-forms-controls which provides all possible info about a selected form (far more than you actually need here!)



    You could import form frmFormInfo into your app together with any required code . . . or just use the relevant parts of the code
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  5. #5
    Micron is online now Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    I copied this long ago from somewhere but am not sure who to give credit to. It might have been Albert D. Kallal
    Try this
    I would set the forms "auto center" property to yes.
    I would set the forms "auto re-size" property to NO

    Now, size the form exactly the way you want, and then save the form (use ctrl-s to save the form).

    Now, flip the form into design mode, and change the border style to "thin". Flip back...ctrl-s.

    This means that you, or your users will NOT be able to change the form size unless it is in design mode (as a general rule..that is how I design ALL my forms anyway).
    So, really, to control this max/min issue, and control the size, you don't need any code...but you do have to pay attention to the forms settings.

    If you don't want you, or users to min/max the forms, then you can remove this option in the forms properties setting. Just change the min/max Buttons setting to "none". If the this "min/max buttons" form setting is none, then even if a form on top is maxed, when you return to the previous form, it will NOT be maxed since the min/max buttons setting is gone!
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  6. #6
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    479
    All very useful, Thank you everyone.

  7. #7
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    479
    Micron, following your suggestions... get to step 3 and size (by dragging) the Form before Saving with ctrl-s.
    Then you say flip back to design mode, but I'm already in design mode after setting the properties. Should I not be?
    After flipping from design to Form view the Form becomes full screen.
    Have I missed something? Should I set PopUp to yes at some stage?

  8. #8
    Micron is online now Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    No, you would be in form view when sizing. He should have said that I guess. Set the properties in design view (1st 2 lines) then flip to form view, size and save. Then the rest.
    I might have a hand written version of it. I'll look for it later and see if it's any better.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 26
    Last Post: 11-03-2021, 09:11 AM
  2. Replies: 1
    Last Post: 08-15-2020, 04:34 AM
  3. Replies: 1
    Last Post: 07-09-2017, 06:02 PM
  4. Replies: 1
    Last Post: 01-24-2017, 09:50 AM
  5. Replies: 3
    Last Post: 07-20-2012, 11:41 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