Add zoom control to report status bar

[Guest]

I have a report that must be opened in dialog mode (because the next line of
VBA code after the line that opens it pops open a MsgBox, and the only way I
could find to delay opening of the Msgbox until the report is closed was to
use Dialog window mode.

However, now the user cannot zoom or do page setup while the report is open;
the dialog mode prevents menu access. Is there a way to embed a page setup,
print, and zoom control in the status bar of the report itself (next to the
page selector)?

Other ideas on how to accomplish the underlying task?

 

[fredg]

I have a report that must be opened in dialog mode (because the next line of
VBA code after the line that opens it pops open a MsgBox, and the only way I
could find to delay opening of the Msgbox until the report is closed was to
use Dialog window mode.

However, now the user cannot zoom or do page setup while the report is open;
the dialog mode prevents menu access. Is there a way to embed a page setup,
print, and zoom control in the status bar of the report itself (next to the
page selector)?

Other ideas on how to accomplish the underlying task?

Is there any reason why you don't simply move the message box to the
report's Close event? Should solve your problem.

 

[Brendan Reynolds]

Move the code that displays the message box to the Close event of the
report?

 

[Guest]

Duh! Thanks for rescuing me from a case of tunnel vision here.