Product Guide

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:

• Overview of Total Access Memo
• Features and Benefits
• Running Total Access Memo
• General Information
• Conclusion

---

Total Access Memo Overview

Background

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:

• Word is a large program that takes a long time to load. Trying to use Word as an editing solution on table data is almost always unworkable.
  
• Embedding Word in an Access form using OLE is generally unstable as the links break on any machine that is not configured identically to the build machine.
  
• Word does not offer a solution for Access reports, where the need for formatted text is often the most acute.

Similarly, some have tried to use the Microsoft Rich Text ActiveX control as a solution. This control exhibits the following problems:

• As a Microsoft ActiveX control, the Rich Text control is prone to failure if an application installs a newer version. Microsoft often updates controls as part of an application's installation process, leading to non-functional ActiveX controls.
  
• The Rich Text control does not reliably support data-binding in Access reports.
  
• The Rich Text control offers no capability for editing text other than typing into the control itself. There are no provisions for applying formatting, changing fonts, or any of the other content options people need with rich text.
• The Rich Text control doesn't support spell checking which is critical as people enter more text.

The Total Access Memo Solution

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 now support Access 2010 (32-bit version), 2007, 2003, 2002, and 2000.

New Features

Total Access Memo includes these new features:

• Support for forms and reports and the Access 2007-2010 ACCDB database format while maintaining support for MDB databases from Access 2003, 2002, and 2000.
• Revised runtime distribution library and sample database with code
• Enhanced spell checker with support for these languages:
  • English (Australia, Canada, New Zealand, UK, US, Zimbabwe)
  • Dutch
  • French
  • German (Austria, Switzerland, Germany)
  • Italian
  • Norwegian (Bokmal, Nynorsk)
  • Portuguese
  • Spanish (Spain, Mexico)
  • Swedish

---

Features and Benefits

Total Access Memo includes a complete set of features to make it easy to add rich text formatting.

Feature	Benefit
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 Access 2010, 2007, 2003, 2002, and 2000	One package gives you the complete rich text solution for your Access 2000 to 2010 (32-bit version) databases.

Properties

The following table shows all properties supported by the Total Access Memo control:

Name	Description
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

Methods

The following table shows all methods supported by the Total Access Memo control:

Name	Description
AboutBox	Displays an about box
CloseEditor	Closes the editor
Find	Finds text
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

Events

The following table shows all events supported by the Total Access Memo control:

Name	Description
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

Running Total Access Memo

Installation Instructions

A standard setup program is included. Just follow the steps and point to the directory you where you want to install the program.

Running the Sample Application

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 and 2010.

---

General Information

System Requirements

The requirements for Total Access Memo are:

• Microsoft Access 2010 32-bit, 2007, 2003, 2002, or 2000
• Microsoft Windows and hardware that supports Access
• 10 MB of free hard disk space

Product Packaging and Documentation

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.

---

Conclusion

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.