Helping you work smarter

memo-field

Truncation of Memo fields

http://allenbrowne.com/ser-63.html In Access tables, Text fields are limited to 255 characters, but Memo fields can handle 64,000 characters (about 8 pages of single-spaced text) – even more programmatically. So why do memo fields sometimes get cut off? Queries Access truncates the memo if you ask it to process the data based on the memo: aggregating, de-duplicating, formatting, and so on. Here […]

>>

,