Subreport Display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem that I don't know how to fix. Basically, I have a
subreport which displays a memo field, but when I try to run the report, it
cuts off some of the text in the memo. "Can grow" is set to yes.

Specifically, the memo should look like this:

Peter Piper
picked a peck of pickled
peppers
Good work.

But instead, it displays like this:

Peter Piper
picked a peck of pickled
peppers
Go

Since it's definitely growing to accomodate to accomodate the multiple lines
of text and the length of the longest sentence, it's just cutting off the
last bits of the last line.

Thanks for your help!
 
mllestecchino said:
I am having a problem that I don't know how to fix. Basically, I have
a subreport which displays a memo field, but when I try to run the
report, it cuts off some of the text in the memo. "Can grow" is set
to yes.

Specifically, the memo should look like this:

Peter Piper
picked a peck of pickled
peppers
Good work.

But instead, it displays like this:

Peter Piper
picked a peck of pickled
peppers
Go

Since it's definitely growing to accomodate to accomodate the
multiple lines of text and the length of the longest sentence, it's
just cutting off the last bits of the last line.

Thanks for your help!
Click to expand...

If you have any formatting on a memo field in the query/table or on the
TextBox used to display it then the text will be truncated at 255
characters. Also if a memo field is used in a GroupBy in a query or if the
query is using DISTINCT.
 
I had been using "Unique Values" set to Yes in my query to stop it from
repeating the entry.

Is there another way for me to prevent duplicate errors and still get to
display more than 255 characters?
 
Use a totals query and group by all the fields EXCEPT the memo field. You
can use First or Last on that field.
 
Back
Top