I have created several reports that I want others to use, but when they try to preview the report it gives an error that it couldn't retrieve the printer info. How do I set the report so it will use the person's default PC? In the end I want to use a macro to output the report to WORD, but this fails too. I have UserDefaultPrinter set to TRUE and LayoutForPrint to FALSE to use screen fonts. Everyone has access to different printers. Suggestions?

PamS

The way I have solved this with no code is to install a network printer that everyone can access, on all user computers. After that, you can use that printer when you develop your reports.
Do not use your local printer for development.
Also do not set default printer to true.

Trying to work with so many different printer drivers is a pain because they are not compliant with one another.





Sal

Thank you. Obviously not the answer I was looking for, but will give it a try.

PamS