Text truncated 3

[TimTDP]

I am using Access 2000

I have a report which is based on a query. One of the fields' in the query is a memo field.

When I run the report, the data from the memo field is sometimes truncated - esp if it contains lots of characters.

How do prevent this?

 

[SeeThru]

Do you mean running the report to screen?

Check the can grow and can shrink help files - quite a few things will stop it working properly.

I have found that sometime putting the bit I want into a one-to-one subform helps.

 

[TimTDP]

I does not matter if I preview or print the report. The text is still truncated.
I have set both "Can Grow" and "Can Shrink" to yes.

 

[CosmoKramer]

Do you have any formatting applied to the control on the report?? If so, remove it. A MS KB article says:

When you apply formatting to a Memo field, the formatting is treated as a Text field, which has a 255-character limit. The data is not physically truncated, but only 255 characters are viewable.

Si hoc legere scis, nimis eruditionis habes

 

[TimTDP]

I have no formatting.

 

[CosmoKramer]

Some other things to check:

Check the Can Grow property for the report section that this memo field is in. It should be set to Yes there too if there isn't enough space in the section for the text box to grow.

Is there any grouping being done on the field in the query? If so, try changing it to select the first or last instance of it....

Si hoc legere scis, nimis eruditionis habes

 

[TimTDP]

I think that the problem is because my report is based on a query. If I create a simple report with the table as the record source, I don't have the truncation problem.

To get around the problem I have used a DLookUp function. It works, but it is not the most efficient method!

 

[BoxHead]

Tim,

I've been playing around with this because I've got a report that doesn't truncate memo fields even when they are way above the 255-character max for a text field.

What I found is if the query is a totals query, the field is truncated in the report. If it is not a totals query, the field is not truncated.

HTH

John

Use what you have,
Learn what you can,
Create what you need.

 

[SeeThru]

Aha!

Any query that manipulates a memo file converts the memo field to Text. And the max size of a text field is 255 characters.

Base the report on a query that is just a basic select query - avoid total or crosstab.