Provide an easy way to share Rich text between Access and other Office Applications
Access 2007 added the Rich Text control so we can store rich formatted text in Access. What it forgot to add was an easy way to share that formatted text in Excel or Word. Please add a means to share the rich text data in at least other Office apps and a easy way to strip the formmatting when exporting to formats like .csv.
Raphael Hein commented
Sorry Kent, I have to correct you ;-) If you want to export Rich Text to e. g. Word, you have to export the contents of each Access RT field to a .htm file on disk, then insert it using an INCLUDETEXT field. If you insert it by Selection.Text, all the tags are inserted as text, not as format instructions. We need a Selection.RichText instruction (or something similar) to insert the formatted text.
Please correct me if I am wrong but it appears to me that the Rich Text in Access is proper html and the issue is more with Excel not being able to display this, or even Access Web Apps for that matter.
You can use the PlainText() function to strip the html tags when exporting.
Chris Naylor commented
Agreed, especially with the ability to strip formatting / html tags when exporting.