Access 2007 not retaining a form's window size

[MEohMY]

Hello,

I had the same issue. I changed the coordinates on the Gridlines to X=1 and Y=1 and that did it for me. The dafault is 24 and 24 made the form show up big.

Hope this helps.

[Teknorapor]

AnyDave, your solution is the best. Thanks

[Terry Welch]

Make the form popup and it will retain and remember it's size

[twinnyfo]

I have found this to be a problem in cases where it is not a conversion from older to newer versions of Access. It is simply a "quirk" that, to my knowledge, no one has been able to provide a reasonable explanation of "why" it happens.

However, all solutions provided, at some point, seem to work more or less. As a standard on my DB, I hide my DB window, have all forms as Overlapping, Popup, Modal, AutoResize, AutoCenter all on; Borderstyle Thin and FitToScreen off. I also typically turn off all navigation controls and embed coded controls, unless I need them.

Since I have clamped down on the default form capabilities, it seems like I have had no problems at all.

One technique that seems to exasperate this problem is using the form in Continuous mode with a header and footer. These love to resize themselves, so I have completley gone away from them and gone to a main form with subforms in such cases.

I hope these few nuggets help.

[zmbd]

THis is a known problem

http://msdn.microsoft.com/en-us/library/office/bb240693(v=office.12).aspx

I also have this happen when using reports...
I have a main form that upon first open does so correctly. If the user calls for a report... i have them open in a small window... all is good... however, if the user maximizes the report window, closes it, then when the main-menu form opens it also opens maximzied; however as the frontends are all mde when the user closes the FE and re-opens all is good.

Something I've had some success with is a tweek on #12 with the restore command and the standard pixel count:

   DoCmd.Restore
   Me.InsideHeight = 2 * 1440
   Me.InsideWidth = 5 * 1440

Wish this was my solution; however, Found this code while looking for a answer some time awhile ago ('07ish?)... I usually tweek the 2 and 5 to get the size I want then start the design.

-z