VBA test for report opened in acViewNormal or acViewPreview?

  • Thread starter Thread starter Mark Hammer
  • Start date Start date
M

Mark Hammer

In a report's close event, I want to test to see whether it was opened in
acViewNormal or acViewPrint.

Surely there's a way to do that, right?

TIA,

Mark Hammer
Lake Oswego, Oregon
 
In a report's close event, I want to test to see whether it was opened in
acViewNormal or acViewPrint.

Surely there's a way to do that, right?

TIA,

Mark Hammer
Lake Oswego, Oregon
Click to expand...

The report's Activate event only fires in Preview, so you can declare
a variable in the declarations section of the Report's code sheet and
set it to =1 in the Activate event then read that variable in the
close event. If the value is 0, it was NOT opened in preview.
 
Back
Top