Rich text formatting

[Paul Shapiro]

I thought that Access 2007 support for rich text would be more useful. I
realize it's HTML, and not RTF, which is fine, but the rich text setting on
a text box only supports very minimal HTML. For example, there's no support
for subscripts and superscripts. I would consider using a plain text box for
editing in this application since the html is mostly generated elsewhere and
transferred into this db. But I still need to:
a) display the formatted text
b) include the formatted text in reports
c) build Word documents with the formatted text.

I don't see that Access 2007 includes any of these capabilities. Is there
any alternative other than 3rd party controls for display and reporting? I
have written code to build complicated Word documents with text that
includes custom formatting tags, but I was hoping that inserting html text
to a Word document would be more straightforward than trapping all the tags
and replacing them with Word styles. I would appreciate suggestions for any
of these 3 requirements.

 

[roccogrand]

Paul,

You have to set RTF twice for memo fields in Access 2007, once in the table
and once on the form. Do the table first and then the form. After you do
this, your text will appear in RTF on your form.

When you output the data to a report, the report will display the RTF. And
when you export to PDF, the memo fields will also display the RTF.

This will solve (a), (b), and (c). I can't seem to get sub/superscripts to
work. Perhaps someone else can suggest a solution for it. Word loses
graphics and RTF in my experiments. Perhaps I am doing something wrong.

HTH

David