Access: Maximize report window but not affect other windows in Access 2003/XP/2000/97

Question:  In Access 2003/XP/2000/97, how can I maximize the report window but not affect the window state of other windows?

Answer:  To maximize the report window, you will need to place code on your report object both on the Open event as well as the Close event. The code on the Open event will maximize all windows, while the code on the Close event will return all windows back to their original state (ie: normal, minimized, maximized).

On the Open event of the report, paste the following code:

Private Sub Report_Open(Cancel As Integer)

DoCmd.Maximize

End Sub

This code will maximize the report window that you are viewing.

On the Close event of the report, paste the following code:

Private Sub Report_Close()

DoCmd.Restore

End Sub

When the report is closed, the system will restore the window state of other windows. (ie: normal, minimized, maximized)