ACC2000: Formatted Memo Field Appears to Truncate Data After 255 Characters (259893)
The information in this article applies to:
This article was previously published under Q259893 Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
SYMPTOMS
When you apply formatting, such as a closing or opening angle bracket
(> or <), to a field with the Memo data type, the data in the field
appears truncated after the 255th character.
CAUSE
When you apply formatting to a Memo field, the formatting is treated as a Text
field, which has a 255-character limit. The data is not physically
truncated, but only 255 characters are viewable.
RESOLUTION
If you export your table to an Excel worksheet, you can view the contents of the Memo field, but without the formatting.
MORE INFORMATION
Microsoft Access versions 2.0 and 7.0 behave differently,
in that they apply your format only to Memo fields that contain 255 characters
or fewer; the Format property is ignored in Memo fields that are longer than that.
REFERENCESFor additional information, click the article numbers below
to view the articles in the Microsoft Knowledge Base:
208404 ACC2000: Fixed-Width Text with Embedded Carriage Returns Is Imported Incorrectly
208801 ACC2000: Memo Field Truncated When Report Is Output to Excel
| Modification Type: | Major | Last Reviewed: | 6/24/2004 |
|---|
| Keywords: | kbprb kbusage KB259893 |
|---|
|