Maximized form coming 'unstuck'

[dajabo]

Thanks if anyone can offer a suggestion, I cannot find a similar problem described on the forum.

I have a form which runs at startup maximised. Pop-up and Modal are set to 'NO', Auto Resize and Center are also set to 'NO', Border style has been set to various settings, and Moveable has also been tried at 'YES' and 'NO'.

A command button on this form opens another form with the same settings which I want to take the original form's 'place' in the application window.

This all works fine, just that when I close the second window (using DoCmd.Close), the original window is then no longer maximised underneath it. I want to make sure certain windows are maximised at all times.

I know I could hack this with a DoCmd.Maximise somewhere, (or by switiching to full Pop-up/Modal mode and hiding the Application window) but the results of these are all a bit of a hack.

Can anyone shed light on the mysteries of Access's default form maximisation behaviour?

Or does anyone do what I have described successfully?

 

[ShaneMan]

Thanks if anyone can offer a suggestion, I cannot find a similar problem described on the forum.

I have a form which runs at startup maximised. Pop-up and Modal are set to 'NO', Auto Resize and Center are also set to 'NO', Border style has been set to various settings, and Moveable has also been tried at 'YES' and 'NO'.

A command button on this form opens another form with the same settings which I want to take the original form's 'place' in the application window.

This all works fine, just that when I close the second window (using DoCmd.Close), the original window is then no longer maximised underneath it. I want to make sure certain windows are maximised at all times.

I know I could hack this with a DoCmd.Maximise somewhere, (or by switiching to full Pop-up/Modal mode and hiding the Application window) but the results of these are all a bit of a hack.

Can anyone shed light on the mysteries of Access's default form maximisation behaviour?

Or does anyone do what I have described successfully?

Hey dajabo,

It's been awhile since I had to deal with a problem similar to yours but read up on Restore. It's seems that is a function I used to solve my problem.

DoCmd.Restore

Hope I'm remembering right and not steering you wrong.

HTH,
Shane

 

[allan57]

I also place the docmd.maximise in the forms activate event, that tends to cure the problem.

 

[dajabo]

thanks shaneman and allan57.

Yes I could use Maximize again or Restore.

I guess I don't see why I should and I'm wondering why Access is un-Maximising a window that should be Maximised.

I was under the impression that if one non-pop-up/modal window is maximised inside the application window then all will be, even if forms are being opened and closed using vba (with the correct settings).

I can only think there is a setting on one of my forms or functions causing this behaviour, though of course you don't have access to my db to tell.

 

[ShaneMan]

I can only think there is a setting on one of my forms or functions causing this behaviour, though of course you don't have access to my db to tell.

Your welcome. I would say there has to be something too, cause I am creating a db now, that is doing exactly what your doing and I have no problems. I have a Home Page form max'd, pop/modal and then have forms open on top of it that are not max'd but are pop/modal (so they'll show up) and do not have any problems with the Home Page min'd.

Hope you get to the root of your problem.
Shane