Steve Schapel
miscellany at mvps.org
Mon Jul 21 17:10:31 CDT 2008
Thank you very much for this ingenious idea, A.D. Expecting there to be no way, I have now tacked the problem in a different way. Besides, some of the reports I was looking at would be only 1 page. Nevertheless, your answer has given food for thought, and added to my knowledge and understanding of the report process. Regards Steve A.D.Tejpal wrote: > Steve, > > One way for programmatic detection of report's open status (Print or > Preview) could be by checking whether the print event of page header > on page 2 has fired closely after Page event on page 1. Of course > this presumes a report sized more than one page. > > Sample code in report's module, as given below, should be able to do > the needful. > > Detecting print preview status could be somewhat trickier, as the > report can sit on page 1 itself for a prolonged period. Thus we can > not keep waiting for the print event on page 2 to fire. For tackling > this situation, we can use form's Timer event. Sample code in form's > module, as given below, in conjunction with the global variable in > general module as shown, should be able to detect print preview > status of the report. >