Microsoft KB Archive/281153

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

Article ID: 281153

Article Last Modified on 9/23/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.

Additional query words: access2000 access2k acc2000 acc2k export excel memo truncate shortened cut off

Keywords: kbbug kbfix kbqfe kbhotfixserver KB281153

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.