Memo Fields Only Displays 255 Characters

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I have created a report from a querie. The query only
displays 1 record. That record is decided made up from 2
form variables. i.e, it only displays the current record
that is open on the main form AND only the current sub-
form data that is in view at the time of pressing the
button.

In the sub form, I have 4 memo fields. All of which, when
Print Previewed in the Report only display the first 255
characters.

How do I get the report Memo fields to display more than
255 characters

In much hope


Adam
..
 
Adam, this will happen if you have some kind of aggregation in your query.

If the query contains a GROUP BY clause, change the Total row under each
memo field to "First" instead of "Group By".

If the query contains DISTINCT or DISTINCTROW, drop that word.


The other issue that can cause this is anything in the Format property of
the text box on your report, or in the Format property of the field in your
table.
 
Check the datasheet view of the query to see if the full memo fields are
shown in the query. You may need to remove words like "Distinct", "Group
By", or "UNION". If this is not the case, make sure the text box's Format
Properties are empty.
 
I have checked the Query and the full text is in there !!

But not in the Report. I can't see any formatting in the
original Tables or in the report...

I removed the Group By and replaced with First... but this
just then asked me to Enter in the Memo Values when I ran
the report...

Still confused... but thank you so much so far...

Adam
 
Magic... just dropped inthe FirstOf[FieldName] and it
works a treat...

Thank you Thank you Thank You !!

Adam
 
Back
Top