Thank you for your interest in Total Access Memo. FMS is pleased to provide you with this Product Guide to assist in your evaluation of this product. The contents of this document are organized as follows:
The need for formatted text in Access has existed as long as Access itself. Users and developers are constantly looking for ways to include formatting within fields. Formatting like fonts, bullet points, indentation, colors, images and alignment.
Unfortunately, Access provides no native way to accomplish this. The typical solution is to invoke Microsoft Word through automation to achieve rich text. The problems with this approach are many-fold:
Similarly, some have tried to use the Microsoft Rich Text ActiveX control as a solution. This control exhibits the following problems:
Since Access 2.0, we have been supplying our Total Access Memo product to solve these needs. Total Access Memo provides a complete rich text editing solution that works in form and reports, and supplies a robust editing environment.
With our latest release, we have added a range of new features, improved performance, and support for 32-bit versions of Access 2016, 2013, 2010, 2007, 2003, 2002, and 2000.
Total Access Memo includes these new features:
Total Access Memo includes a complete set of features to make it easy to add rich text formatting.
|A rich text control that works on Access forms and reports||You can incorporate rich text with fonts, colors, bullets, formatting, and hyperlinks right in your Access Database. Using Total Access Memo is as simple as placing the control on your form or report.|
|Full screen, rich text editor||Our pop-up editor can be invoked from within Access or as a standalone application. Launch the editor to create, edit, and format rich text with menus, rulers, toolbars, etc.|
|Rich formatting||Total Access Memo supports full font, color, attributes, bullets, indents, justification, hyperlinks, and complete editing capabilities.|
|Programmatic Interface||All the functionality available from the Total Access Memo editor is also available programmatically. You can use VBA code to completely configure how Total Access Memo works and interacts with your application.|
|Supports Multiple Access Versions||One package gives you the complete rich text solution for your Access 2000 to 2016 (32-bit version) databases.|
The following table shows all properties supported by the Total Access Memo control:
|Appearance||Obsolete property; kept only for compatibility with the Microsoft RTF control|
|AutoVerbMenu||Determines if the control automatically displays a right-click menu|
|BackColor||Determines the background color of the control|
|BorderStyle||Obsolete property; kept only for compatibility with the Microsoft RTF control|
|BulletIndent||Sets the default indentation for bulleted paragraphs|
|DataChanged||Indicates if the data in the control has changed|
|DisableNoScroll||Obsolete property; kept only for compatibility with the Microsoft RTF control|
|Echo||Determines if screen updating is turned on|
|EditorEnabled||Determines if the editor can be launched from the control|
|EditorTitle||Sets the title that appears in the editor|
|Enabled||Determines if the user can manipulate the control|
|FileName||Specifies the file loaded into the control at design time|
|FixedRightMargin||Sets the right margin in the editor to the width of the control in the form|
|Font||Sets the default font used in the control|
|ForeColor||Sets the default font color used in the control|
|HeightOfText||Returns the height of the text in the control|
|HideSelection||Determines if the selection is hidden when the control loses focus|
|Hyperlinks||Returns or sets a value indicating if hyperlinks are enabled|
|HWnd||Returns the handle to the control window|
|Locked||Determines if the control is locked from user input|
|MaxLength||Sets the maximum length of the text (in characters) that can be entered into the control|
|MouseIcon||Returns or sets a custom mouse icon|
|MousePointer||Determines the mouse pointer used in the control|
|MultiLine||Determines if the control supports more that one line of text|
|OLEObjects||Exposes a collection of OLEObject objects|
|RichEditVer||Returns the version of RichEdit|
|RightMargin||Determines the right margin|
|ScrollBars||Determines the scroll bar style|
|SelAlignment||Determines the alignment of the currently selected text|
|SelBold||Determines if the current selection is bold|
|SelBullet||Determines if the current selection is bulleted|
|SelCharOffset||Determines the text offset from the baseline|
|SelColor||Determines the foreground color of the currently selected text|
|SelectionBar||Determines if you can select lines at the right of the control|
|SelFontCharSet||Returns or sets the character set of the current selection|
|SelFontName||Sets the font name of the current selection|
|SelFontSize||Sets the font size of the current selection|
|SelHangingIndent||Sets the size of the hanging indent of the current selection|
|SelHyperlink||Determines if the text specifies a hyperlink|
|SelIndent||Sets the indent (first line indent)|
|SelItalic||Determines if the current selection is Italic|
|SelLength||Determines the length of the current selection|
|SelRightIndent||Sets the right margin indent of the current selection|
|SelStart||Sets the character position of the beginning of the selection|
|SelStrikeThru||Determines if the current selection has a line drawn through it|
|SelTabCount||Returns the tab count of the current selection|
|SelTabs||Returns the SelTabs collection|
|SelText||Determines the text of the current selection|
|SelUnderline||Determines if the current selection is underlined|
|SelValue||Determines the RTF value of the current selection|
|Text||Determines the text in the entire control|
|TextDocument||Exposes the TextDocument object from the control|
|Value||Determines the RTF value of the entire control|
The following table shows all methods supported by the Total Access Memo control:
|AboutBox||Displays an about box|
|CloseEditor||Closes the editor|
|FindReplace||Finds and replaces text|
|GetCharFromPos||Returns the character at the specified coordinate position|
|GetLineFromChar||Returns the line number based on a character position|
|GetPosFromChar||Returns the coordinate position based on a character position|
|LoadFile||Loads the contents of a file into the control|
|OpenEditor||Opens the editor|
|Refresh||Forces the control to repaint|
|SaveFile||Saves the contents of the rich text control to a file|
|SelPrint||Prints the current selection|
The following table shows all events supported by the Total Access Memo control:
|Change||Fired when the contents of the control change|
|Click||Fired when the control is clicked|
|DblClick||Fired when the control is double clicked|
|EditorClose||Fired when the editor closes|
|EditorOpen||Fired when the editor opens|
|KeyDown||Fired when a key is pressed down|
|KeyPress||Fired when a key is pressed|
|KeyUp||Fired when a key is released|
|Link||Fired when a hyperlink is clicked|
|MouseDown||Fired when the mouse is pressed down|
|MouseMove||Fired when the mouse is moved|
|MouseUp||Fired when the mouse is released|
|SelChange||Fired when the selection changes|
A standard setup program is included. Just follow the steps and point to the directory you where you want to install the program.
The quickest way to get up to speed with the power of Total Access Memo is to run the sample application. The sample is a standard Access database containing forms, reports, and code that show how to use the Total Access Memo custom control in your application. The sample database is in an Access 2000 file format, and can be used in Access 2000, 2002, 2003, 2007. 2010, 2013 and 2016.
The requirements for Total Access Memo are:
Total Access Memo includes a CD with a full setup program, documentation, online help and sample applications. A 130 page printed user manual is also included describing the program and how to use each property, method, and event.
Total Access Memo Pricing
for Microsoft Access
|Microsoft Access Version|
|Licenses||Price||2016, 2013 and 2010 (32-bit),
2007, 2003, 2002, 2000
Premium Support Subscription
Also Available as part of:
Total Access Ultimate Suite
|Royalty-free redistribution rights are included in the purchase price.|
Total Access Memo is licensed on a per developer basis.
Each developer who uses the program must have a license.
Total Access Memo is the most powerful rich text solution available for the Microsoft Access development environment. Able to provide complete content formatting on forms and reports, Total Access Memo combines power and ease of use.
We invite you to put the product through its paces, and contact us if we can provide any additional assistance in evaluating or deploying Total Access Memo.
Microsoft, Microsoft Office Access, SQL Server, Visual Basic for Applications, and Microsoft Windows are either registered trademarks or trademarks of Microsoft Corporation. Total Access Memo is a trademark of FMS Inc. All other trademarks are trademarks of their respective owners. Total Access Memo is copyright by FMS Inc. All Rights Reserved.
Supports 32-bit versions of Microsoft Access 2010, 2013 and 2016, and Access 2007, 2003, 2002, and 2000!
"Total Access Memo makes all the difference in my Access apps! Only Memo gives me fonts, colors, images and all the formatting tools I need. It's great!"
B. Simmons, Ciena, Linthicum, MD