Memo Field Truncating in Word

[Guest]

Hi,

I have read responses for this problem and followed all the suggestions and
my memo field still truncates when I export to Word (rtf). Have I missed
something? The suggestions I followed were:

1. Make sure the report is not performing any grouping on the memo field.
Particularly it should not be listed in the report's Sorting'n'Grouping
dialog, with a group footer or header.

2. Make sure the report's query is not grouping on the memo field. It it is
a Totals query, try changing the Total row under the memo to "First" instead
of Group By". You will need to change the Name and Control Source of the
text box on the report as well: it will come out something like
"FirstOfMemo1".

3. Make sure the report's query does not include the DISTINCT keyword (i.e.
Unique Values set to Yes in the query properties.) This will also cause the
memo to truncate.

4. Make sure there is nothing in the Format property of the text box on the
report, and nothing in the Format proeprty of the memo field in the table.
These things cause it to truncate.

Of course, the memo could also be truncating because the text box on the
report is not big enough to show all the characters. Setting its Can Grow
property to Yes will help (assuming there is nothing else overlapping the
text box vertically on the report), and check that the (Detail?) section's
Can Grow is also set to Yes.

Thanks

 

[Ken Snell [MVP]]

To add one more to your list of "watch out for" items:

Be sure that your query does not contain a calculated field that uses the
Replace function with the memo field.
OutputField: Replace([MemoFieldName], "TextToFind", "TextToSubstitute")

 

[Guest]

I don't have that functionality in the query.

To add one more to your list of "watch out for" items:

Be sure that your query does not contain a calculated field that uses the
Replace function with the memo field.
OutputField: Replace([MemoFieldName], "TextToFind", "TextToSubstitute")

--

Ken Snell
<MS ACCESS MVP>

Hi,

I have read responses for this problem and followed all the suggestions
and
my memo field still truncates when I export to Word (rtf). Have I missed
something? The suggestions I followed were:

1. Make sure the report is not performing any grouping on the memo field.
Particularly it should not be listed in the report's Sorting'n'Grouping
dialog, with a group footer or header.

2. Make sure the report's query is not grouping on the memo field. It it
is
a Totals query, try changing the Total row under the memo to "First"
instead
of Group By". You will need to change the Name and Control Source of the
text box on the report as well: it will come out something like
"FirstOfMemo1".

3. Make sure the report's query does not include the DISTINCT keyword
(i.e.
Unique Values set to Yes in the query properties.) This will also cause
the
memo to truncate.

4. Make sure there is nothing in the Format property of the text box on
the
report, and nothing in the Format proeprty of the memo field in the table.
These things cause it to truncate.

Of course, the memo could also be truncating because the text box on the
report is not big enough to show all the characters. Setting its Can Grow
property to Yes will help (assuming there is nothing else overlapping the
text box vertically on the report), and check that the (Detail?) section's
Can Grow is also set to Yes.

Thanks

 

[Ken Snell [MVP]]

I've not used the RTF export very much, but it may be that it uses an older
"version" of Office technology where strings longer than 255 characters
cannot be supported.

--

Ken Snell
<MS ACCESS MVP>

I don't have that functionality in the query.

To add one more to your list of "watch out for" items:

Be sure that your query does not contain a calculated field that uses the
Replace function with the memo field.
OutputField: Replace([MemoFieldName], "TextToFind",
"TextToSubstitute")

--

Ken Snell
<MS ACCESS MVP>

Hi,

I have read responses for this problem and followed all the suggestions
and
my memo field still truncates when I export to Word (rtf). Have I
missed
something? The suggestions I followed were:

1. Make sure the report is not performing any grouping on the memo
field.
Particularly it should not be listed in the report's Sorting'n'Grouping
dialog, with a group footer or header.

2. Make sure the report's query is not grouping on the memo field. It
it
is
a Totals query, try changing the Total row under the memo to "First"
instead
of Group By". You will need to change the Name and Control Source of
the
text box on the report as well: it will come out something like
"FirstOfMemo1".

3. Make sure the report's query does not include the DISTINCT keyword
(i.e.
Unique Values set to Yes in the query properties.) This will also cause
the
memo to truncate.

4. Make sure there is nothing in the Format property of the text box on
the
report, and nothing in the Format proeprty of the memo field in the
table.
These things cause it to truncate.

Of course, the memo could also be truncating because the text box on
the
report is not big enough to show all the characters. Setting its Can
Grow
property to Yes will help (assuming there is nothing else overlapping
the
text box vertically on the report), and check that the (Detail?)
section's
Can Grow is also set to Yes.

Thanks