Memo Field is truncated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My queries are truncating memo field after 255 characters. I want the entire
memo field displayed
 
Here's a list of things to check:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

I was surprised to see that you didn't suggest the trick of
something like Left([MemoField], N), where N is some large number
that is greater than the length of the longest memo field value (I
use 4096 when I have to do this, which is very seldom, thankfully).
Surprisingly, it's not so terribly slow as you might expect.
 
When do you use that, David?
When you Group By the memo?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

David W. Fenton said:
Here's a list of things to check:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html

I was surprised to see that you didn't suggest the trick of
something like Left([MemoField], N), where N is some large number
that is greater than the length of the longest memo field value (I
use 4096 when I have to do this, which is very seldom, thankfully).
Surprisingly, it's not so terribly slow as you might expect.
 
When do you use that, David?
When you Group By the memo?

Or sorting, but when I need the whole field for display purposes. I
have two apps where it's needed, in fact, and was doing it in A97,
before the introduction of that hateful automatic truncation (which I
think is something that shouldn't happen without an affirmative
decision that you want it to happen -- how many questions are asked
about that problem?).
 
Back
Top