Outputting a report to RTF

[NikkiNYCC]

Hello,

I am currently refurbishing a database that was created a few years ago to
incorporate a new statutory question.
To do this I have literally copied all of the tables, queries, reports,
macros etc and dropped them onto a new database.

I have come across a problem with a button that has always worked on the old
database, this button is at the bottom and is supposed to Output to RTF. I
have simply copied the old form with the button and expected it to work. It
appears that the various reports which feed into the RTF are not working as
it is only bringing up one of the reports.

Unfortuately I am not HTML trained and cant figure the difference between
the two reports.

Is there any way I can build a new report including all of the fields I need
and set that to RTF instead?

Its the making an automatic rtf that I am having problems with, as I would
have just written a new one if I could.

Any help would save my life, as I have put an emergency word/mail merge
document in place for the time being

Thanks

 

[mscertified]

Normally you create a normal Access report and after it is generated, you
export it to RTF.
HOWEVER, RTF will not retain all the formatting of an Access report.
Only snapshot format will do that.
So you need to rethink your strategy.

Dorian

 

[Dennis]

What mscertified said is true. You create a report, period. Once the report
is created and works to your satisfaction, you can then add code to save it
(export it) as an RTF file. Note that LINES AND PRETTY BOXES and stuff DO NOT
save in an RTF file, but only in a SNP (snapshot) file. While you can EDIT an
RTF doc in Word, you cannot edit an SNP file.

Hope this helps.