Save a report to a file

GeoNelix

Registered User.
Local time
Today, 09:51
Joined
Aug 27, 2002
Messages
30
This should be an easy one. How do I save a report to a file as an rtf using VBA? Is it the TransferText method?
 
DoCmd.OutputTo object-type, object-name, output-format, output-file-spec, auto-start-app, template-file-spec

Object type will be acReport.

You name the Access object you want to output, whether report, form, table, query, or module.

Output format can be acFormatRTF if that's appropriate.

You name the file you want as the destination file.

If you don't wish to immediately revise the file with Word, I would suggest setting the auto-start argument to False

Omit the template-file because it doesn't apply to RTF output.


There is a macro-action equivalent to this. Still called "OutputTo" but the type and format arguments are, of course, drop-downs.
 

Users who are viewing this thread

Back
Top Bottom