Print dialog using OpenReport.... acNormal?

Hello all,

Using the following command, is there any way to get the printer dialog to
open? I most packages, when you click print, it will open the printer
dialog, however Access sends the report without the dialog. I was hoping
there would be another option, other than acNormal, but there doesn't appear
to be:

DoCmd.OpenReport Forms!frmOpt.Form!RunName.Caption, acViewNormal

Thanks!

Andy

Re: Print dialog using OpenReport.... acNormal?

"ARC" wrote in message
news:vU%Vi.61518$Um6.38875@newssvr12.news.prodigy.net...
> Hello all,
>
> Using the following command, is there any way to get the printer dialog to
> open? I most packages, when you click print, it will open the printer
> dialog, however Access sends the report without the dialog. I was hoping
> there would be another option, other than acNormal, but there doesn't
appear
> to be:
>
> DoCmd.OpenReport Forms!frmOpt.Form!RunName.Caption, acViewNormal
>
> Thanks!
>
> Andy
>

Replacing acViewNormal with acViewPreview will open the report in preview
mode which will allow you to open the print dialog box and print the report.

Re: Print dialog using OpenReport.... acNormal?

On Wed, 31 Oct 2007 14:00:59 GMT, "ARC"
wrote:

You meant to say: in other packages I don't have the convenience of
printing straight to the default printer. And in Access I can still
get the print dialog: just preview the report and have the user choose
File > Print. :-)

-Tom.


>Hello all,
>
>Using the following command, is there any way to get the printer dialog to
>open? I most packages, when you click print, it will open the printer
>dialog, however Access sends the report without the dialog. I was hoping
>there would be another option, other than acNormal, but there doesn't appear
>to be:
>
>DoCmd.OpenReport Forms!frmOpt.Form!RunName.Caption, acViewNormal
>
>Thanks!
>
>Andy

Re: Print dialog using OpenReport.... acNormal?

Well, the user's are a bit funny, they don't want to preview first! :(

Yet getting the print dialog is still a feature they want.

"ARC" wrote in message
news:vU%Vi.61518$Um6.38875@newssvr12.news.prodigy.net...
> Hello all,
>
> Using the following command, is there any way to get the printer dialog to
> open? I most packages, when you click print, it will open the printer
> dialog, however Access sends the report without the dialog. I was hoping
> there would be another option, other than acNormal, but there doesn't
> appear to be:
>
> DoCmd.OpenReport Forms!frmOpt.Form!RunName.Caption, acViewNormal
>
> Thanks!
>
> Andy