Maximize form when it receives focus 1

[janerussel]

To print reports, I have a pop up form with report selections. The reports are all printed to screen first. The Print Reports Menu appears when the reports come to screen. When I close out the report and the pop-up form, the print report menu disappears leaving a gap at the top of the screen between my main form and the standard access menu.

DoCmd.Maximize only works when the form is first loaded. How do I control this so that the form will always maximize when it receives the focus

 

[Scoty]

is you DoCmd.Maximize on the onload event of the form properties or on the GotFocus event of the form properties?
scoty :

 

[janerussel]

Sorry, I tried this and it doesn't work.

 

[Scoty]

Jane,
is there any reason why you could not close main when you load your reports and report popup menu? if not then you may want to consider closing the main menu when you go to the reports and report popup then on the unload property of the report popup menu

DoCmd.OpenForm "mainmenu"

this will relaunch the mainmenu thus reruning the onload property of

DoCmd.Maximize

and maximize your menu to fit.
Let me know
Scoty :

 

[janerussel]

I followed your advice and closed the main form. It's not what I really wanted to do, but it works fine now. Thank you for your help.

 

[JaneInMA]

You Could also DoCmd.Maximise on the event OnActivate. I have a similar position where we have a problem with speed over a network so I keep the menu form open at all times. Then when the user leaves the data entry screen the database only has to close the data entry form and not reload the menu form.