Export rich text from access to word

[MikeJames]

I am storing pre-formatted data (pasted into a rich text
box from Word) and stored in a memo field. I know about
the rich tesxt control bug that makes it not work in
reports, so I thought I would just export it back to Word.
But when I do this, it shows up with all the metatags on
it instead of showing up pre-formatted.

Can this problem be overcome and how?

 

[John Nurick]

Hi Mike,

AFAIK there are only two ways of doing this:

1) write the RTF string to a .rtf file on disk and open that with Word

2) via the clipboard.

For (2) you need to get the string onto the clipboard as rich text and
not as an ordinary string. Loading it into a rich text control and then
using a CopyToClipboard or similar method of the control should do this.

Alternatively, you can use some API calls in VBA to put the string into
the clipboard with the appropriate CLIPBOARD_FORMAT constant; when you
paste it into Word, this will cause Word to parse it as RTF rather than
paste it as plain text.

I am storing pre-formatted data (pasted into a rich text
box from Word) and stored in a memo field. I know about
the rich tesxt control bug that makes it not work in
reports, so I thought I would just export it back to Word.
But when I do this, it shows up with all the metatags on
it instead of showing up pre-formatted.

Can this problem be overcome and how?

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.