Maximized Window Look Problems

[E.Q.]

Greetings,
I'm trying to polish up a database and thought I'd try to do some cosmetic
things. First, I have a start form (frmStart) that looks good as designed;but
when called from a form or report on a maximized window it would also show up
maximized. I found the "Popup" property and set that to yes but now whenever
I call up a report or form from frmStart, frmStart remains on top, blocking
the object I was trying to open. Am I missing a property somewhere or will I
need to put a bit of code in to make sure frmStart gets out of the way when
another object is called up.
Another question regarding Maximized window: the Help screen directed me to
the DoCmd.Maximize command and I inserted that so reports open on a more
readable screen. I'd like to orient the sheet so the user sees the form at
the upper left.
As I reread this I realize the connection between the two issues may seem a
bit tenuous, please forgive the "two-for-one" shot, but I have a hunch that
both issues will be quite simple for an experienced developer to solve.
Peace
EQC

 

[boblarson]

This is what I do, I put this in each report's On Open event:

DoCmd.Maximize

And then in the On Close event of each report:

DoCmd.Restore

So, you can then leave your forms sized as is and then when they close the
reports it resets things back to their pre-maximized size.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[E.Q.]

Thank you...
I had a hunch it wouldn't be the most complicated of problems to solve, Mr.
Larson. Your solution is simple and thus elegant.
Regards,
EQC