How do i programatically print a report to a postscript file?? The only related link I can find in these forums is [URL="http://www.access-programmers.co.uk/forums/showthread.php?t=57034&highlight=print+report+postscript+file"] but nobody has responded. Is there anyone here who knows how to do this?

TIA

Install a postscript printer driver of your choice. In the printer properties change the port setting to FILE.

Cheers Neil , however please read again my post .. "How do i **PROGRAMATICALLY** print....." , i.e. I do not wish to do this manually.

I have already installed a PS driver and managed to print to this programatically however what I want to do is print the PS output to a file (.PRN).

This does work programatically! The printer settings persist.

If you mean that you don't want the user to have to supply the file name, then I don't know if you can pass this to the printer driver. You may have to use some third party software.

The driver is a network shared resource and in addition is used on any given user profile for a number of different applications, therefore I really need to explicitly set this up when my database is opened, so yes I do not want any manual process for configuration.

My fear was that Access97 provides little if no support for what I require, Access2003 is much better for this however our client PCs have Access97 installed under a contractual arrangement so we cannot upgrade.