Bug: Field Exported to RTF File Randomly Truncated (Access 2000)

[Guest]

I need to create a Word file from an Access 2000 report. A snapshot file
will not suffice because client needs to be able to edit the file.

The report has two subreports. One of the subreports contains a text field
with CanGrow set to True. When I output the report to an rtf file, the last
word of the text field randomly disappears. A related problem is discussed
at http://support.microsoft.com/default.aspx?scid=kb;en-us;288877

I've tried adjusting the width of the text field, changed the font, and
added a right margin to the text box. I've also checked for control
characters like two hard carriage returns. I've tried converting the mdb
file to Access 2003 and outputting the rtf file from Access 2003.

I do not own Adobe Acrobat.

None of the above corrects the problem. Should I use VBA automation to
create a bug-free Word file from an Access report?

 

[Rick Brandt]

I need to create a Word file from an Access 2000 report. A snapshot
file will not suffice because client needs to be able to edit the
file.

The report has two subreports. One of the subreports contains a text
field with CanGrow set to True. When I output the report to an rtf
file, the last word of the text field randomly disappears. A related
problem is discussed at
http://support.microsoft.com/default.aspx?scid=kb;en-us;288877

I've tried adjusting the width of the text field, changed the font,
and added a right margin to the text box. I've also checked for
control characters like two hard carriage returns. I've tried
converting the mdb file to Access 2003 and outputting the rtf file
from Access 2003.

I do not own Adobe Acrobat.

None of the above corrects the problem. Should I use VBA automation
to create a bug-free Word file from an Access report?

The RTF export feature has always had this problem and there is no fix for it.
Any fix that appears to work will only be for the specific data being tested at
the time. Other runs of the same report with different data will still truncate
somewhere along the line.

I would suggest automation or a merge routine.

 

[Guest]

Thanks for your helpful and candid response, Rick.

Since the report is pretty complicated, I think I may concatenate " ***" to
the end of the buggy textbox during output to an rtf. Then, I'll use
automation to search and replace " ***" with "" in the output Word file.
Maybe that will make the automation quick and easy.

 

[Bogdan]

"I would suggest automation or a merge routine"

How it can be done ? Thanks.