Memo Field is truncated

[Guest]

My queries are truncating memo field after 255 characters. I want the entire
memo field displayed

 

[Guest]

Share your SQL view for near instant gratification...

 

[Allen Browne]

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

 

[David W. Fenton]

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.

 

[Allen Browne]

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.

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.

 

[David W. Fenton]

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?).