Form display

[Guest]

Most of my custom forms open full screen although Auto Resize property is set
to No. What should I do to have a consistent form sizing each time my form
opens.

Thanks!

 

[Rick Brandt]

Most of my custom forms open full screen although Auto Resize
property is set to No. What should I do to have a consistent form
sizing each time my form opens.

Thanks!

They are most likely maximized which has noithing to do with their "size".

Access is an MDI application which means if you maximize one inner window
you maximize all of them (and if you restore one you restore all). Word and
Excel are similar in this regard. The only excpetion is if you open a
dialog or popup form.

 

[Brendan Reynolds]

I use code similar to the following in the Form_Activate event procedure ...

Private Sub Form_Activate()

Application.Echo False
DoCmd.Restore
DoCmd.RunCommand acCmdSizeToFitForm
Application.Echo True

End Sub

 

[Guest]

Rick and Brendan:

Thank you gentlemen. Both method worked out.