MS Access 2003: Maximize report window but not affect other windows
This MSAccess tutorial explains how to maximize a report window but not affect other windows in Access 2003 (with step-by-step instructions).
Question: In Microsoft 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)
Advertisements