ACC: Formatted Memo Truncates Data at 255 Characters (103998)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 97
This article was previously published under Q103998 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, it is treated as a Text
field, which has a 255-character limit. The data is not physically
truncated, but only 255 characters are viewable.
STATUS
This behavior is by design. Microsoft Access 2.0 and 7.0 behave differently
in that they only apply your format to Memo fields that are 255 characters
or less; the Format property is ignored in Memo fields longer than that.
| Modification Type: | Major | Last Reviewed: | 11/14/2003 |
|---|
| Keywords: | kbbug kbusage KB103998 |
|---|
|