output memo to RTF

[J. Freed]

I've got an application in 2003 that takes the contents of memo fields and,
through a report, outputs them to RTF. We've just noticed that, in a single
instance, one word was truncated in going from the report. The line was less
than 255 characters and had no unusual characters. All the other memo lines,
of varying length, are going through with no difficutly. Any ideas how to
deal with this? It's doubly frustrating because when we add or delete to this
field everything comes out; it only seems to happen with this particular
record at this particular length. TIA...

 

[Rick Brandt]

I've got an application in 2003 that takes the contents of memo fields
and, through a report, outputs them to RTF. We've just noticed that, in a
single instance, one word was truncated in going from the report. The line
was less than 255 characters and had no unusual characters. All the other
memo lines, of varying length, are going through with no difficutly. Any
ideas how to deal with this? It's doubly frustrating because when we add
or delete to this field everything comes out; it only seems to happen with
this particular record at this particular length. TIA...

Export as RTF has always had this problem and it cannot be fixed. If you
tweak the report so that the current record and field starts working you
will just see the problem surface on other records or with other field
lengths.

RTF is only usable for very simple tabular output. Anything else will do
this at some point.

 

[J. Freed]

Thanks, this confirms what I've seen in several other notes. Since I wanted
to retain some formatting, I changed the process to:

1) add HTML codes via the query to reflect what I want in the text
2) export to a text file
3) copy the contents of the text file into Word, which retains the coding
and executes it accordingly