I export reports to MS Word using a rich text file format. Using this method, all I get is the text. I would like all of the lines that seperate each record to be exported as well. I have not been successful in doing this. Does any one know how to do this? ( Or am I wishing on a Star??)

RTF files strip the lines. To get an exact copy of your report, you could use Adobe Acrobat.

Adobe Acrobat is the solution I used. You could also export to a Snapshot file, but, you have to have the Snapshot viewer installed on the computer being used to view it. It is available free from microsoft.

Is there any way to save a report as a snapshot file using VB Code, or do you have to Save As/Export from the Print Preview manually? Ideally, I'd like to export a report to a .snp file without any user intervention required.