Background

Total Access Memo lets you add rich text format (RTF) memos to Microsoft Access with sophisticated editing and spell checking.

Question

How do I get unformatted text with Total Access Memo?

Answer

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.

Additional Support Resources

• Support Options
• Product Information
• FAQs
• Updates
• User Manual
•  PDF Fact Sheet