Total Access Memo

Total Access Memo CD and Manual

Microsoft Access 2007-2016 Version
is Shipping!


Supports 32-bit versions of Microsoft Access 2010, 2013 and 2016, and Access 2007, 2003, 2002, and 2000!


View all FMS products for Microsoft AccessAll Our Microsoft Access Products

Memo Info:

 

"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

Additional Info:

 

 

Rich text format memo fields for Microsoft Access forms and reports with Total Access MemoRich text format memo fields for Microsoft Access forms and reports Free trial download of Total Access Memo

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:


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.

Total Access Memo Products
by Microsoft Access Version

License Price 2016, 2013 and 2010 (32-bit),
2007, 2003, 2002, 2000

Single $299 Buy Now
5 Seat $899 Buy Now

Upgrades

Single $199 Buy Now
5 Seat $599 Buy Now

Premium Support Subscription

Single $299 More Information
5 Seat $999

Also Available as part of:

Total Access Ultimate Suite

Runtime/Redistributable Version

Royalty-free redistribution rights are included in the purchase price.

Licensing Information

Total Access Memo is licensed on a per developer basis. Each developer who uses the program must have a license.

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.