|
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:
- Create a new ADP and create a table with following columns:
| Field |
Data Type |
| PK |
Int, autoincrement |
| LargeTxt |
varchar(3000) |
- Create an autoform based on the table.
- 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.
- Save.
- 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
-
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.
|
