Total Access Memo lets you add rich text format (RTF) memos to Microsoft Access with sophisticated editing and spell checking.
When using Total Access Memo, why do I lose all formatting when programmatically editing the text property?
With Total Access Memo, if you are updating the control's Text property with code like this, you will lose your rich text formatting:
tamMemo.text = tamMemo.text & "New Text"
The Text property applies to the the unformatted text contents of the control. Updating this property replaces all formatting and text in the control. Use the SelStart and SelText properties to append text into the control.