How to tell when a report is 'open' to maximize

  • Thread starter Thread starter Michael Daly
  • Start date Start date
M

Michael Daly

I have some reports that take some time to perform their
formatting. I want to know how I can test when the report
is finished formatting, and is 'open' to send
the 'DoCmd.Maximize' command to that report only. If I use
the 'DoCmd.Maximize' command prior to the report
being 'opened' after formatting, Access maximizes and
displays a hidden form (my menu form). This looks ugly,
and I want to make sure I only maximize the 'Report', and
not other forms.

Is this possible?

Thanks... Michael
24 June 2004
 
Try . . untested

Private Sub Report_Close()
DoCmd.Minimize
End Sub

Private Sub Report_Open(Cancel As Integer)
DoCmd.Maximize
End Sub

HTH
 
why not just open the report maximised in the first place? Other option is
put the docmd.maximise in the report.open event.
 
In properties on the report itself (you don't even have to open a VB
window):
On Open
=[DoCmd].[Maximize]

On Close
=[DoCmd].[Restore]

HTH
Mich
 
Back
Top