Why does my memo field truncate the data?

[Julie]

I have a comments field with the data type set to memo. I thought memo
fields were supposed to store unlimited characters, but my responses are
truncated. When I look at format I see this:
\800

What does that mean? I didn't put it there? Is that causing this problem?

 

[Rick Brandt]

I have a comments field with the data type set to memo. I thought memo
fields were supposed to store unlimited characters, but my responses are
truncated. When I look at format I see this:
\800

What does that mean? I didn't put it there? Is that causing this problem?

Yes, if you apply any format property to a memo field it truncates at 255
characters.

 

[Jerry Whittle]

Where are they truncated? Form or Report?

The \ symbol displays the next character as a literal character. You can
also display literal characters by placing quotation marks around them. It
also tends to make the fields right aligned in the datasheet view. I don't
think that's the problem.

 

[Julie]

Rick, thanks. Can you tell my why \800 was inserted into the format? I
didn't put it there?
Thanks,
Julie

 

[Julie]

Jerry, they are truncated in the form. I haven't tried running any reports
yet.
Julie

 

[Rick Brandt]

Rick, thanks. Can you tell my why \800 was inserted into the format? I
didn't put it there?
Thanks,

Sorry. No idea.

 

[John W. Vinson]

Rick, thanks. Can you tell my why \800 was inserted into the format? I
didn't put it there?

Whether you did or somebody else did... just remove it. That's a meaningless
format anyway!

John W. Vinson [MVP]