ACC2000: When You Export an Access Report the Memo Field Is Truncated

This article was previously published under Q281153
This article has been archived. It is offered "as is" and will no longer be updated.
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.
RESOLUTION
To 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
IMPORTANT: 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.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
access2000 access2k acc2000 acc2k export excel memo truncate shortened cut off
Properties

Article ID: 281153 - Last Review: 12/05/2015 23:00:15 - Revision: 4.2

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kbhotfixserver kbqfe kbbug kbfix kbqfe KB281153
Feedback