471,354 Members | 1,516 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

Display the Report to the screen instead of automatically printing.

52
I have a report which I am opening from a command button within a form. I am using the “DoCmd.OpenReport stDocName” command to open the report but it is automatically printing instead of popping the report to the screen. How can I stop it from printing and just have the output sent to the screen?

Any help would be greatly appreciated.

Thanks
Birky
Jan 23 '07 #1
3 7194
MMcCarthy
14,534 Expert Mod 8TB
This should do it ...

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport stDocName, acViewPreview
Jan 24 '07 #2
Birky
52
Thanks much, this produced the exact results we were looking for.
Feb 1 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Thanks much, this produced the exact results we were looking for.
You're welcome.

Mary
Feb 1 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Marc | last post: by
reply views Thread by =?Utf-8?B?amRzdGVudG8=?= | last post: by
1 post views Thread by Ron | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.