Free trial download of Total Access Memo

Frequently Asked Questions for Non-Current Versions of Total Access Memo

Total Access Memo 2002 (for Access 2000/2002)

Total Access Memo 2000 (for Access 97/2000)

Total Access Memo 97 (for Access 95/97)


How can I get spell checking to work in Total Access Memo 2002?

Total Access Memo uses the spell checker included in Microsoft Office 2000 or XP proofing tools. Please note the following limitation of the Total Access Memo's spell checker:

  • In the first release of Total Access Memo 2002, Spell checking features were only available in US-English Windows and Office environments. This issue has been resolved in the latest update.
  • In the first release of Total Access Memo 2002, the user was required to have local administrator privileges in order to use spell checking functionality. This issue has been resolved in the latest update.
  • The Microsoft Office SpellChecker must be invoked from MS Office *prior* to allowing it to be invoked from our own FMS Rich Text Editor. This means that MS Access, Word, Excel or other MS Office document must have used the Spell Checker for MS Office at least one time prior to invoking it from our application. This only needs to be done one time after the MS Office feature is installed.

How can I get spell checking to work in Total Access Memo 2000?

Total Access Memo uses the spell checker included in Microsoft Office 97 proofing tools.

At the time that Total Access Memo was released, Microsoft did not to allow third party vendors (such as FMS, Inc.) to distribute the vital components necessary to use the Spell checking features of Microsoft Office 2000. For this reason, spell checking will only be enabled if the user has the MS Office 97 Spell checking features installed on their machine.


How do I get Total Access Memo to grow and shrink properly on Access 97 reports?

You can adjust the height of the Total Access Memo control and if the report section's CanGrow property is set to Yes, the section grows as well. However, when the control shrinks, the report section's height does not automatically shrink and the it cannot be changed programmatically. Basically, once a report section increases its height, it cannot be reduced without re-running the report.

Fortunately, there is a simple way to trick Access into resizing its report section. Read the following FAQ for more information:

How do I get Total Access Memo to grow and shrink properly on reports?

How can I get spell checking to work in Total Access Memo 97?

Total Access Memo uses the spell checker included in Microsoft Office proofing tools.

Unfortunately, Total Access Memo 97 only supports spell checking when the user is logged in to the machine with Admin privileges. To work around the issue, please ensure that you have Admin privileges on the machine where you are using the product.


When using Total Access Memo 97 on a Windows 2000 or Windows XP machine, I get error 11, "Division by Zero."

Since Total Access Memo 97 was created prior to the release of Windows 2000 or Windows XP, it will not work on these platforms. Total Access Memo 2000 and Total Access Memo 2002, however, will work on both Windows 2000 and Windows XP.

For information on upgrading to the latest version, please contact our Sales department: Sales@fmsinc.com


How do I get Total Access Memo to grow and shrink properly on reports?

You can adjust the height of the Total Access Memo control and if the report section's CanGrow property is set to Yes, the section grows as well. However, when the control shrinks, the report section's height does not automatically shrink and the it cannot be changed programmatically. Basically, once a report section increases its height, it cannot be reduced without re-running the report.

Fortunately, there is a simple way to trick Access into resizing its report section:

  1. In the report section where your Total Access Memo control resides, size the section to its maximum height: click on the Section and set it's height property to 22 inches. Then, set the Can Grow and Can Shrink properties of the Section to "Yes".
  2. Create a text box in the section where the Total Access Memo control resides. The Left and Top properties of this text box should each be 0. This places the text box at the extreme top left of the section.
  3. Size the new text box so that it is as high as the section. Do this by setting the height property of the new text box to 22 inches, then set the CanGrow and CanShrink properties of the text box to "Yes".
  4. Set the Visible property of the new text box to No. This "tricks" Access into shrinking its section properly, but is not visible when the report is previewed or printed.
  5. Paste the following code in the module for the report:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.tamNotes.Height = Me.tamNotes.HeightOfText
End Sub

where tamNotes, is the name of your Total Access Memo control and the Detail_Format is the section where the Total Access Memo control resides. For more information please review the Total Access Memo help file under the section Using the Control on Access Reports.

Please note that Microsoft has resolved this issue in MS ACCESS 2000 by providing a method to shrink the detail section in code! This is not resolved in MS ACCESS 97 and this workaround is still needed there.

Total Access Memo Manual and CD

Microsoft Access 2007-2016 Version is shipping!

New Features

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


View all FMS products for Microsoft Access All Our Microsoft Access Products

Reviews

Best ActiveX Control
Best ActiveX Control

"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

Memo Info

Additional Info

Question

 

 

Free Product Catalog from FMS