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

Article translations Article translations
Article ID: 281153 - View products that this article applies to.
This article was previously published under Q281153
Expand all | Collapse all

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.

Properties

Article ID: 281153 - Last Review: September 23, 2005 - Revision: 4.2
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbhotfixserver kbqfe kbbug kbfix kbqfe KB281153

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com