Memo Field is truncated

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 04 Apr 2007 03:34 GMT

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

Signature

Bob

Reply to this Message

Duane Hookom - 04 Apr 2007 05:08 GMT

Share your SQL view for near instant gratification...

Signature

Duane Hookom
Microsoft Access MVP

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

Reply to this Message

Allen Browne - 04 Apr 2007 09:35 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

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

Reply to this Message

David W. Fenton - 04 Apr 2007 18:05 GMT

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

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

Allen Browne - 05 Apr 2007 01:41 GMT

When do you use that, David?
When you Group By the memo?

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>> Here's a list of things to check:
>> Truncation of Memo fields
[quoted text clipped - 6 lines]
> use 4096 when I have to do this, which is very seldom, thankfully).
> Surprisingly, it's not so terribly slow as you might expect.

Reply to this Message

David W. Fenton - 05 Apr 2007 20:30 GMT

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

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message