export an rtf report

[jeff]

Can anyone please see why this code isn't producing a
file named "test.rtf" upon closing the report - Thanks


Private Sub Report_Close()

DoCmd.OutputTo acOutputReport, "Report1",
acFormatRTF, "test.rtf"

End Sub

 

[Tony]

Jeff;
I do not know if this will help you much, but I tried
your code here and it worked!!??

Are you on 98, 2000 or XP. I have heard of problems
with rtf, snp and pdf files with XP, and rtf and pdf on
2000. However I have not run into it the same way you
have. I know this sounds dumb, but did you do a search to
see if it went into a different directory?

Good Luck

Tony

 

[Steve Schapel]

Jeff,

The first thing I would fix is putting a full path reference for the
output file, e.g. "C:\MyFolder\test.rtf"

- Steve Schapel, Microsoft Access MVP