Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Bugs: Access 2000 ADPs: Memo field corruption

Author(s)
Mary Chipman
 

If you are using bound forms in Access Data Projects that display Memo (Char/VarChar) fields, Access may corrupt the data stored in that field at save time.

To reproduce this error:

  1. Create a new ADP and create a table with following columns:
    Field Data Type
    PK Int, autoincrement
    LargeTxt varchar(3000)



  2. Create an autoform based on the table.
  3. Copy and paste the following into LargeTxt.
    Now is the time for all good men to come to the aid of their country.
    Now is the time for all good men to come to the aid of their country.
    Now is the time for all good men to come to the aid of their country.
    The quick brown fox jumped over the lazy dog. The quick brown fox
    jumped over the lazy dog. The quick brown fox jumped over the lazy
    dog. The quick brown fox jumped over the lazy dog. The quick brown fox
    jumped over the lazy dog.
  4. Save.
  5. If you go back to the record after moving off of it, and load it in the zoom box, you get:
    Now is the time for all good men to come to the aid of their country.
    Now is the time for all good men to come to the aid of their country.
    Now is the time for all good men to come to the aid of their country.
    The quick brown fox jumped over the lazy dog. Now is the time for all
    good men to come to the aid of their country. Now is the time for all
    good men to come to the aid of their country. Now is the time for all
    good men to come to
  6. if you try again to re-paste the original paragraph over the screwed up one, it looks fine in the zoom box, but saving the record and re-reading it again duplicates the screwed-up text of the second paragraph.

Although the Knowledge Base article listed below does not address this data corruption behavior, it does acknowledge problems with specific data types in ADPs:

When you view the contents of a char, nchar, varchar, or nvarchar column in an Access project containing 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.

Article ID: 244010
ACC2000: Char/Nchar and Varchar/Nvarchar Values Displayed Incorrectly in an Access Project


1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer