Total Access Memo lets you add rich text format (RTF) memos to Microsoft Access with sophisticated editing and spell checking.
How do I get unformatted text with Total Access Memo?
Occasionally, you may just want the text and not the rich text format of the RTF field. For instance, you may want the unformatted text on a report, or you may need to export the text to another program that does not support rich text format fields.
Total Access Memo exposes a property called Text. The Text property returns the textual representation of the contents of the Total Access Memo control.
If you want to store it in a separate field, create an extra memo field for it. Use the Text property in BeforeUpdate event of your form, as in the following:
Private Sub Form_BeforeUpdate(Cancel As Integer) ' Assign the text representation to the text field TextField = tamDemo.Text End Sub
Where TextField is the name of the text field, and tamDemo is the name of the Total Access Memo control.