Convert RTF Text to ASCII Text
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!