Stopping the Printing Dialog when Outputting Reports

V

Van T. Dinh

Try:

Screen.Echo False
DoCmd.OutputTo ...
Screen.Echo True

Beware that Echo Off freeze the screen and if the process
takes a long time, the user may think that Access has got
stuck.

And to be safe, you need to trap for *any* error and the
set Echo True to get the screen active again.

See Access VB Help on Echo for arguments.

HTH
Van T. Dinh
MVP (Access)
 
Top