Force form to load standard size (not maximized) (A2k)

Topic

New Reply

I have a few forms that I’d like to force the form size, (so when a user closes a datasheet form that they had maximized, they’re not stuck looking at a maximized form that only takes up 2″x4″ of the screen…)

Is there a property to set for this?

Reply | Quote

Replies

You could put the line

DoCmd.Restore

in the On Activate event of the forms.

(You could set the Popup property of the forms to Yes, since popup forms come up non-maximized by default, but that might have unexpected/undesired side effects: popup forms float in front of all other Access windows and aren’t bound to the Access application window.)

Reply | Quote

Thanks Hans, that works great.

Also – thanks for the additional info with popup forms

Reply | Quote

If you want to stop your user from resizing a form that you have set up, put the following code in the form’s Resize event.

DoCmd.RunCommand acCmdSizeToFitForm

Reply | Quote

I leave all the forms borders set as thin, so they can’t anyways

Reply | Quote