Forms resize themselves

[pam0566]

I am using access 2007 to update an old db. The records are still 2003. When i open up a few of the forms, they open maximized, which is not what i want. I have resized them, changed fit to screen to no, changed autosize to yes, made them thin border not resizable... nothing works. Some of my other pop ups are fine, its only 3 forms that do this, and i cant seem to figure out how to change it. Any ideas?

 

[dkinley]

hehe .. good call. It is a new thread.

Hmmm .. strange. That is how mine are set up - note, though, I did the following for a reason a bazillion years ago and it is part of my routine, I have no idea why I keep doing it unless this is it.

I do not have any forms that are ever maximized; however I don't know if this makes a difference, but my reports are not set up with the properties Fit to Page - Yes (they are set to 'no'). I maximize them OnOpen() - DoCmd.Maximize and when I return to the form it has not changed size (unless I design the form while maximized.)

An observation (without testing and its sound dumb) is that the system updates the form property across all forms on the last one called. As a way to test, try changing your switchboard form properties from Fit to Page - Yes to No and use the DoCmd.Maximize on the OnOpen().

Or ... check out the DoCmd.Restore -- I just know it restores the size in some capacity, I've never used it.

Hope all of that helps and/or made sense.

-dK

 

[pam0566]

i figured it out. those particular forms had the do.cmd.maximize on them, took that out and works great. thanks!!

 

[dkinley]

You betcha.

-dK