|
Microsoft
Access 2007 Version
|
|
| 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!" |
|
| Additional Info: | |
|
|
|
|
|
|
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)
How can I get Spell Checking to work in Total Access Memo 2000?
How do I get Total Access Memo to grow and shrink properly on Access 97 reports?
Total Access Memo 97 (for Access 95/97)
How can I get Spell Checking to work in Total Access Memo 97?
How do I get Total Access Memo to grow and shrink properly on reports?
Total Access Memo 2002 (for Access 2000/2002)
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.
Total Access Memo 2000 (for Access 97/2000)
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?
Total Access Memo 97 (for Access 95/97)
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:
Email: Sales@fmsinc.com
Toll Free: (866) 367-7801
Local: (703) 356-4700
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:
- 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".
- 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.
- 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".
- 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.
- 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.
