ACC: Concatenation of Memo Fields Creates Text FieldLast reviewed: May 28, 1997Article ID: Q92892 |
The information in this article applies to:
SYMPTOMSModerate: Requires basic macro, coding, and interoperability skills. When you use a make-table query to concatenate two Memo fields, the query concatenates the Memo fields into a Text field in the resulting table. If you have more than 255 characters combined in the two Memo fields, the data is truncated in the new Text field.
CAUSEText fields have a limit of 255 characters; Memo fields can contain up to 32,000 characters in Microsoft Access 1.x, and up to 64,000 characters in Microsoft Access 2.0 or later.
RESOLUTIONTo work around this behavior, use an append query on an existing table with a Memo field and concatenate the two Memo fields into the existing Memo field. For example:
MORE INFORMATION
Steps To Reproduce Behavior
|
Keywords : kbusage QryMktbl
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |