Article ID: 244010
Article Last Modified on 11/25/2002
APPLIES TO
- Microsoft Access 2000 Standard Edition
This article was previously published under Q244010
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access project (.adp).
SYMPTOMS
When you view the contents of a char, nchar, varchar, or nvarchar column in an Access project that contains a value with more than 256 characters, the first 256 characters of the string are repeated, regardless of the contents of the whole column value. Characters after the 256th position are not displayed at all.
RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).
To obtain SR-1/SR-1a, click the article number below 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)
To temporarily work around this problem, use the SQL Server text or ntext data type instead of char, nchar, varchar, or nvarchar.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.
MORE INFORMATION
Steps to Reproduce Behavior
- In an Access project connected to SQL Server or Microsoft Data Engine (MSDE), create the following table named TestTable:
Column Name Data Type Length Allow Nulls Identity Primary Key MyPk int 4 No Yes Yes MyChar char 1000 Yes No No MyText text 16 Yes No No - Save the table.
- Open the newly created table in Datasheet view.
- Press ALT+F11 to start the Visual Basic Editor.
- Press CTRL+G to open the Immediate window.
- Type the following line of code in the Immediate window, and then press ENTER:
?string(100,"a") & string(100,"b") & string(100,"c") & string(100,"d")
- Highlight the entire 400-character string in the Immediate window to select it, and then on the Edit menu, click Copy to copy the string to the Clipboard.
- Close the Visual Basic Editor.
- Paste the string from the Clipboard into both the MyChar and MyText columns of the TestTable table.
- Click in the MyText column and press SHIFT+F2. Note that the string is displayed correctly in the Zoom box.
- Click OK to close the Zoom box.
- Click in the MyChar column, and then press SHIFT+F2. Note that after 256 characters (the 56th letter "c"), the string is repeated. No letter d's are ever displayed.
Additional query words: pra
Keywords: kbbug kbclientserver kbpending KB244010