lock form size (access 2000)

Topic

New Reply

hi all,

I can recall reading something about this before but I can’t find the post anymore. maybe someone knows?

the thing is this
I have a couple forms and what I want is to open some forms maximized and
some in normal format. what happens now is that if I open the first form and
normalize it all the other forms open in normalized format too. or when I
maxime a form all the other forms that are opend next are maximized too.
how can I change this?
how can I set for every form apart in what way it should open
It is probably a simple thing in the form properties but I’ve tried all I
could find and nothing seems to make a difference.

Thanks ahead.

Diederik

Reply | Quote

Replies

A form with Popup = Yes (in the Other tab of the Properties window), or opened using DoCmd.OpenForm with the WindowMode argument set to acDialog, is always opened “restored” regardless of the state of other forms. that way, you can open a “restored” form on top of a maximized form. But otherwise, maximizing one window within Access will maximize all others too, and ditto for restoring one window. That is the way the multi-document interface (MDI) works.

Added: you could resize forms in code to fill the Access window without being maximized, using DoCmd.MoveSize.

Reply | Quote

Hi Hans,

the popup option could be a good solution.
But then one more question is how do I get access to close the form at lostfocus?
couse I have a couple forms that open in “normal” format

(this is actually what I couldn’t find in the first place so thats why I went searching for fixing the form size)

Tnx,

Diederik

Reply | Quote

If you also set Modal = Yes (or use DoCmd.OpenForm with acDialog) the user cannot activate other windows in the database; (s)he must close the modal window before activating another window.

Reply | Quote

If you also set Modal = Yes (or use DoCmd.OpenForm with acDialog) the user cannot activate other windows in the database; (s)he must close the modal window before activating another window.

Reply | Quote

Hi Hans,

the popup option could be a good solution.
But then one more question is how do I get access to close the form at lostfocus?
couse I have a couple forms that open in “normal” format

(this is actually what I couldn’t find in the first place so thats why I went searching for fixing the form size)

Tnx,

Diederik

Reply | Quote

A form with Popup = Yes (in the Other tab of the Properties window), or opened using DoCmd.OpenForm with the WindowMode argument set to acDialog, is always opened “restored” regardless of the state of other forms. that way, you can open a “restored” form on top of a maximized form. But otherwise, maximizing one window within Access will maximize all others too, and ditto for restoring one window. That is the way the multi-document interface (MDI) works.

Added: you could resize forms in code to fill the Access window without being maximized, using DoCmd.MoveSize.

Reply | Quote