How do I use the PlainText function in Access 2007?

FallsChurchGuru
FallsChurchGuru used Ask the Experts™
on
I have a Description field in a table where I've specified the text format to be Rich Text. In reports, the contents of the field are displayed with HTML tags. When I created a test table with a memo field formatted with Plain Text, Access 2007 indicated that I should use the PlainText function to display the text as plain text if the memo field text format was changed to Rich Text. I would like the text format of the field to remain Rich Text so that I can use tabs and carriage returns when entering data into this field. However, in reports, I need the data to print as plain text (without the HTML tags). How do I use the PlainText function in an update query to temporarily change the text format to plain text for this field?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
The PlainText method can be used in a query like this:

SELECT MyRichTextColumn, PlainText(MyRichTextColumn) As MyPlainText FROM YourTable

To do this in the Query designer, move to a blank column and type this in the Name row:

MyPlainText: PlainText(MyRichTextColumn)

Obviously you'd have to substitute your Column names.
Hamed NasrRetired IT Professional

Commented:
You can use PlainText function as you use Left function, but plainText removes formatting of input text.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial