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

[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

 

[Newbie]

Try . . untested

Private Sub Report_Close()
DoCmd.Minimize
End Sub

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

HTH

 

[KB]

why not just open the report maximised in the first place? Other option is
put the docmd.maximise in the report.open event.

 

[M Skabialka]

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