Entire Text Not showing.

[Linda RQ]

Hi,

I have a comment field. Originally the property in the table was set to
text with 255 character limit. A comment was typed in but was truncated. I
changed the field propery to memo. I deleted the text and re-typed the
comment. All the text went in. On the report I sed the control to Can Grow
and Can Shrink. More of the text prints out but it gets cut off too. The
funny thing is, I used the LEN function in excel to see how many characters
were in the comment and it's only 190. Why did it get truncated in the
first place and why won't it completely print out on my report? I am using
Access 2003.

Thanks,
Linda

 

[Rick Brandt]

Hi,

I have a comment field. Originally the property in the table was set
to text with 255 character limit. A comment was typed in but was
truncated. I changed the field propery to memo. I deleted the text
and re-typed the comment. All the text went in. On the report I sed
the control to Can Grow and Can Shrink. More of the text prints out
but it gets cut off too. The funny thing is, I used the LEN function
in excel to see how many characters were in the comment and it's only
190. Why did it get truncated in the first place and why won't it
completely print out on my report? I am using Access 2003.

Thanks,
Linda

If your query is using Group By on the memo field it will be truncated. If
it has a format property it will be truncated (query or report). If the
query is using DISTINCT it will truncate. If you group on the field in your
report it will truncate.

I probably missed a few, but suffice to say that there are numerous things
you can do that will cause a memo field's output to be truncated.
HOWEVER... any truncation that you see would be at 255 characters, not 190
so I can't explain what you are seeing there.

 

[LMB]

If your query is using Group By on the memo field it will be truncated.
If it has a format property it will be truncated (query or report). If
the query is using DISTINCT it will truncate. If you group on the field
in your report it will truncate.

I probably missed a few, but suffice to say that there are numerous things
you can do that will cause a memo field's output to be truncated.
HOWEVER... any truncation that you see would be at 255 characters, not 190
so I can't explain what you are seeing there.

My query is using the group by. Is there a way to fix this so the text is
not truncated?

Thanks,
Linda