Memo field cuts text

A

ant1983

Hi,

I have a report running of a straight-forward query. I have a field called
memOutcomes which is a Memo field.

The text in that field seems to cut off in my report and it seems at the
same amoutn of characters in each line - what could cause this?
 
M

Marshall Barton

ant1983 said:
I have a report running of a straight-forward query. I have a field called
memOutcomes which is a Memo field.

The text in that field seems to cut off in my report and it seems at the
same amoutn of characters in each line - what could cause this?
Click to expand...


Lots of things will truncate memo fields to 255 characters.

Setting the text box's Format property to anything

Using anything in the report's record source query that
needs to compare the memo field. For example:
DISTINCT
GROUP BY
ORDER BY
etc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text box in report is truncating memo field at 255 characters 2
How do you allow memo fields to break for pages. 1
Memo in Report causing blank pages/other issues 2
Reports: memo field won't display more than 255 characters 1
How do I force a memo field to print all text in reports? 2
Memo field is truncating in group heading of an Access 2007 report 3
Canshrink question!! 2
Report cuts off data from memo field 2

Top