Total Access Memo lets you add rich text format (RTF) memos to Microsoft Access with sophisticated editing and spell checking.
With Total Access Memo, using the control on a sub form: Give the ActiveX control focus and I can't type in any other text field on my main or other subforms.
There is a known issue with ActiveX controls when applied or used on a sub form in Microsoft Access. When an ActiveX control is used on a sub form, if focus is given to another form (this could be either a sub form or a parent form), there are errors that occur. The most consistent of these errors is that you cannot type any values into a text field after using an ActiveX control on a sub form. Also, the OnFocus / OnLostFocus events for the ActiveX control are not always trapped by Access. This is a result of the functionality of Microsoft Access in terms of the way that it interacts with 3rd party ActiveX controls like Total Access Memo.
While we have not developed a workaround for this, please review the following URL for a possible work around from Microsoft:
The above article applies to Access 2000 and higher and is a demonstration of this concept with the Treeview ActiveX control (which encounters the same symtoms).
We have taken the initiative to notify Microsoft as well as our development team regarding this issue. We would like to thank you for reporting this to us. We always welcome feedback that can help us improve our products and technical documentation to better suit the needs of our customers.