Rich text problem

[Guest]

I have an access 2003 database linked to a sql database records system to do
ad-hoc reporting. My problem began when the company upgraded us to a new
version.
When i run a report in access they have a narrative field that is rich text
now. anything prior comes over fine. Any new entries have the following text
before the text we put in

{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Tahoma;}}

Is there any way to remove that from showing up on report

Any help would be appreciated.

John
University of Pennsylvania Crime Analyst

 

[David Lloyd]

John:

I don't know all of your specifics, however, you may want to reference the
following KB article.

http://support.microsoft.com/kb/838010/en-us

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I have an access 2003 database linked to a sql database records system to do
ad-hoc reporting. My problem began when the company upgraded us to a new
version.
When i run a report in access they have a narrative field that is rich text
now. anything prior comes over fine. Any new entries have the following
text
before the text we put in

{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Tahoma;}}

Is there any way to remove that from showing up on report

Any help would be appreciated.

John
University of Pennsylvania Crime Analyst

 

[Guest]

Thanks David for the post, Unfortunately it does seem to help my situation.
It does give me more things to think about.