Add zoom control to report status bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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