I have a table of comments. Some of the comments are generated on a web form using an RTF Input box. The contents of this RTF box is then saved to a SQL table into a field txtComment. When I attempt to create an Ad Hoc report using Access 2000, the report displays the RTF formatting tags along with the ASCII text. Is there a utility or Function I can use to "strip" out the formatting tags, ie <par>...</par>, and return only the ASCII text from the field for each record???.

Any assistance would be greatly appreaciated!

Thanks,
Lou

Lou Schweichler

Are this tags just at the beginning and at the end of the string?




Sal

Anyway, if the are, just do a Ltrim and RTrim



Sal