How to stop form opening as "exploding form" 1

[MDLinOz]

I have seen posts on opening a form from another thread and the sequence of

new: open
old: close
..
..
old: open
new: close

was explained, but I want to do the following (with maximised forms)

new: open
old: visible - off
.. (I don't want to close the old form)
..
old: visible - on
new: close.

Problem: The old (original) form no longer jumps up when re-opening (sequence of open-closes is now correct), but when repainting, it "explodes" from a non-maximized to its maximized shape.

When it was made invisible, Access 2000 also un-maximized it.

Any suggestions?

I would also like to remove all right corner sizing and close controls, without using popup/modular.

Any suggestions

TIA
Michael

 

[ZmrAbdulla]

Hi,
You can use Echo property to hide screen updation

DoCmd.Echo False ' This will hide screen updation from the user
DoCmd.Maximize
DoCmd.Echo True ' Restore the screen updation visible after the form has been maximized.

To hide a form while the other to be visible

Forms!SecondForm.Visible = True
Forms!SecondForm.SetFocus
Forms!FirstForm.Visible = False

Hope this helps


Zameer Abdulla

http://www.geocities.com/zameerabd/

http://www.mtkhoory.com