I recently updated from 2003 to 2007 version of Access. In 2003 I had a third
party software from FMS to convert rich text from a sql database to a
readable form in a report. Does 2007 have a way of reading the rich text from
another database and leave out the /par and garbage and just leave the text.
or do I still need a third party software to eliminate it.

Thanks in advance.

No, Access 2007 has nothing to handle *real* rich text.

A2007 supports something that MS *calls* rich text, but it's not, it's
actually HTML (or a subset thereof), so it's no good for real rich text.

Stephen Lebans has a free Rich Text control here, you could try using this
in your reports instead of converting the rich text:

http://www.lebans.com/richtext.htm

"John" <(E-Mail Removed)> wrote in message
news:524FC3B3-BAFC-45B3-96C6-(E-Mail Removed)...
>I recently updated from 2003 to 2007 version of Access. In 2003 I had a
>third
> party software from FMS to convert rich text from a sql database to a
> readable form in a report. Does 2007 have a way of reading the rich text
> from
> another database and leave out the /par and garbage and just leave the
> text.
> or do I still need a third party software to eliminate it.
>
> Thanks in advance.

Thanks, appreciate the help.

"bcap" wrote:

> No, Access 2007 has nothing to handle *real* rich text.
>
> A2007 supports something that MS *calls* rich text, but it's not, it's
> actually HTML (or a subset thereof), so it's no good for real rich text.
>
> Stephen Lebans has a free Rich Text control here, you could try using this
> in your reports instead of converting the rich text:
>
> http://www.lebans.com/richtext.htm
>
> "John" <(E-Mail Removed)> wrote in message
> news:524FC3B3-BAFC-45B3-96C6-(E-Mail Removed)...
> >I recently updated from 2003 to 2007 version of Access. In 2003 I had a
> >third
> > party software from FMS to convert rich text from a sql database to a
> > readable form in a report. Does 2007 have a way of reading the rich text
> > from
> > another database and leave out the /par and garbage and just leave the
> > text.
> > or do I still need a third party software to eliminate it.
> >
> > Thanks in advance.
>
>
>