resizing Forms after opening a reports in Preview

[shepshedlad]

Hi
Is there a way to stop a form altering size when a user click a button to open a report in Preview mode?

Once they close the report (and they often accident use the close button top right corner which closes the whole Database!). The report closes and the original Form has been reduced from its normal (Maximum) size.

Any advice would be appreciative.

regards
Rob

 

[PHV]

In the Activate event procedure of the form you may add this code:
DoCmd.Maximize

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[shepshedlad]

Thanks PH for that, it works great. I would also like to say thanks to all for helping an Access newbie out over the last week with some pretty basic questions. Your help has been very much appreciated.

regards
Rob