I have a form with a lot of information and I wanted it as big on the screen as possible, but if you maximize it in the window it shows the min, max, close buttons even if they are disabled on the form. I got some code from Microsoft that sizes the form on open to the size of the access window and moves it in the upper left corner. It works great.
Except.... when I open a report from the form and then close that report, the form moves down on the screen about 1.5 inches and I can't see the bottom. I have to drag it up. This happens whether I leave it open and visible OR open and not visible. I don't want to close it, because they will be printing the report and continuing to work in the form.
It has to do with maximizing the report, which I do when it opens (or the user could do, no way to turn it off, not that I want to). If I open the report and don't maximize it, the form doesnt't move. If I maximize the report and size back down before closing, the form doesn't move. If the report is maximized when I close it, the form does move.
I have tried putting a DoCmd.Restore in the close and deactivate events of the report, but it doesn't work. I also tried to rerun the code that originally placed the form both in the close report event and in various form events like OnActivate, OnCurrent etc... I know it is a long shot, but does anyone have any ideas?
Thanks.
Kristin
Except.... when I open a report from the form and then close that report, the form moves down on the screen about 1.5 inches and I can't see the bottom. I have to drag it up. This happens whether I leave it open and visible OR open and not visible. I don't want to close it, because they will be printing the report and continuing to work in the form.
It has to do with maximizing the report, which I do when it opens (or the user could do, no way to turn it off, not that I want to). If I open the report and don't maximize it, the form doesnt't move. If I maximize the report and size back down before closing, the form doesn't move. If the report is maximized when I close it, the form does move.
I have tried putting a DoCmd.Restore in the close and deactivate events of the report, but it doesn't work. I also tried to rerun the code that originally placed the form both in the close report event and in various form events like OnActivate, OnCurrent etc... I know it is a long shot, but does anyone have any ideas?
Thanks.
Kristin