ACC2000: When You Export an Access Report the Memo Field Is Truncated (281153)
The information in this article applies to:
This article was previously published under Q281153 SYMPTOMS When you export an Access 2000 report in Microsoft Excel
97-2000 format, text in any Memo field that contains more than 127 characters
is truncated to 127 characters. RESOLUTIONTo correct this problem, obtain the latest service pack for
Microsoft Office 2000.
For additional information, click the
following article number to view the article in the Microsoft Knowledge Base: 276367
OFF2000: How to Obtain the Latest Office 2000 Service Pack
: Before you install Microsoft Office 2000 Service Pack 3 (SP-3),
you must have Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) installed
first. For
additional information about how to obtain Office 2000 Service Release 1/1a
(SR-1/SR-1a), click the following article number to view the article in the
Microsoft Knowledge Base: 245025
OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
WORKAROUND Instead of exporting the report in Excel format, export it
as HTML. However, this provides only a partial solution. When you open the file
in Excel, the text in the Memo field will be spread over multiple cells instead
of being in one single cell. STATUSMicrosoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
| Modification Type: | Minor | Last Reviewed: | 9/23/2005 |
|---|
| Keywords: | kbHotfixServer kbQFE kbbug kbfix kbQFE KB281153 |
|---|
|