Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open Maximized

Status
Not open for further replies.

NetManRob

Technical User
May 16, 2001
20
US
I have two reports that I frequently view and print. Each time I open the report it opens in a small window. How would I go about changing the behavior to open maximized?

Please be very specific, this is my first Access application.

Thanks
 
Are you opening this report through a command button with the OpenReport action?? If so, add this code directly after the OpenReport statement:
Code:
DoCmd.Maximize
 
I recognise the problem you are having.
I have found the best way to approach this is to add

DoCmd.Maximize

to the OnOpen event of all my reports, and also then to add

DoCmd.Restore

to the OnClose event of the reports.

This means that when the reports open, they will be maximised to the full Access window size, but after they are closed, my forms are restored to the normal window size. I find this preferable to including the maximise command in a command button - this works OK for opening, but unless you also include the code in the OnClose event, you will be left stuck with your forms maximised.




 
Hi Guys,

I am opening my reports from a switchboard button. As soon as I figured out where to put the DoCmd statement, it worked great!

Thanks for the help.

Rob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top