I did this once
I think I used a macro to activate the print dialogue box
Then assign the Macro to a tool bar
Then assign the tool bar to the report.
In this way the icon on the tool bar that appears when the report shows call
the print dialogue box rather than just printing the report to the defined
printer.
I expect you can also do the same with code and while macros are old and
clunky they can still solve simple problems in a simple way.
I also added other report related buttons to the button bar such as a close
button that closes the report and reverts to whatever other forms should be
open.
Seemed to work OK as non of the database users complained
Hope this helps
Andrew Hall
"Ian" <ia********@ntlworld.comwrote in message
news:Gk*****************@newsfe2-gui.ntli.net...
I have an Access 97 database, on a Report I have the print option set to
print to the PC’s default printer rather than a printer selected from
the list.
My question is: Can I allow the user to change this setting so that by
default the report will print to a specific printer that they select
rather than the PC’s default printer?
The reason for wanting to do this is that I don’t know the names of the
printers they might have and the DB is an MDE so they cant go to design
view and change it themselves.