Resize Form to Original Size

[kenrav]

I have an Access form which is 8" wide and 6" tall. I minimize it. So far, so good. Unfortunately, when I later maximize it, the form fills the entire screen (which I don't want.) How can I get it to resize to its original 8" x 6" size?

 

[Ranman256]

dont use Maximize. remove any maximize commands.
just open the form :
docmd.OpenForm "fMyform",acNormal ,,,,acWindowNormal

and it should open in its normal size. (as long as youre not using TABBED forms)

 

[MajP]

Try changing the autoresize and autocenter properties

Form.AutoResize property (Access)

Office VBA reference topic

learn.microsoft.com

 

[MajP]

If doing this in code look at the docmd.restore.

 

[isladogs]

@kenrav
Why maximize the form if you dont want it to fill the screen? As @MajP mentioned, restore it instead.

 

[Mike Krailo]

It has been assumed this is all being done in code but could it be this form is manually minimized and then clicking on the wrong icon to restore the form to original size? Should be clicking on the restore icon as shown in this image.

 

[kenrav]

Thanks everyone for your help. My app can sometimes require a user to deal with multiple forms at the same time (this is especially true during lunch time where there may be only one user in the office.) Unfortunately, his/her task bar ends up looking like the attached screenshot. Since he/she may forget which closed form is which, I'm thinking about building a "Minimized Form Manager". Using cmd.restore sounds promising.

 

[isladogs]

That's why the taskbar settings option below is worth using: