Maximise Report using code - not working properly

[jojones]

I am trying to Maximise a Report on Open. The On Open Procedure assigns the RecordSource and changes a few label colours etc. The I have the line

DoCmd.Maximise

What actually happens is, the form which has the command buutton to open the report gets maximised instead of the report. I think this is due to the fact that the query behind the report takes a little while to run... but not sure. Can anybody help and suggest an alternative for Maximising my report.

Cheers
Jo Jones

 

[jitter]

You might try throwing the

Docmd.Maximize in the OnActivate event of the report. That might correct your problem.

Hope this helps....

 

[LarryDeLaruelle]

Jo:

I issue the DoCmd.Maximise immediately after the DoCmd.OpenReport on the calling form:

DoCmd.OpenReport stDocName, acPreview
DoCmd.Maximize

This works for me.
Larry De Laruelle
larry1de@yahoo.com

 

[jojones]

Larry - unfortunately that is what I am doing, but it keeps maximising the calling form before the report opens in preview, I think due to the time it takes for the Reports recordsource query to run.

Merry Christmas - thanks for your suggestions Cheers
Jo Jones