Print dialogue box to open on report

[techkenny1]

Hi all,

Is it possible that when a report is opened that the print dialogue box opens without having to select the print command when you do a right click on the report.
I wanted the print box to be able to go straight to the box where you can put in a filename, save it and then it would be printed.

many thanks

 

[ZmrAbdulla]

A print dialog can't give an option to set a file name.
that is being called from the report open event like

DoCmd.RunCommand acCmdPrint

another way is to export the report as something(html, word, excel, snapshot etc..)

DoCmd.RunCommand acCmdExport

You may look into the other options of [tt]DoCmd.RunCommand[/tt].

Zameer Abdulla