Problem Exporting Report To Word

[Mando13]

I'm trying to export my report to Word. Seems simple but when I do export my report to Word my 'COMMENT' Field only exports over 255 characters. The actuall 'COMMENT' Field is a MEMO Type and my query and report both pull in whole field fine. Can anyone help and tell me how I can get the whole field (more then 255 characters) to export over to Word?

 

[HitechUser]

What is showing up in Word? Just text? Are there embedded CR & LF (carriage return and line feed)?

Not quite clear...

 

[Mando13]

I was able to get the full text to export over to Word. I just moved the fields around in the report design view. I made my COMMENT field longer and the whole text exported over with no problem. Don't know why that would be an issue but it worked. Thanks.

 

[mpat]

How can i pass a access report into word in code.
Like my user will press e-mail button and then i want access to dump the report into word and save the report in a directory i specify and then attach the report into an e-mail. Any idea how i can do this hole piece.

 

[HitechUser]

Start with something like this...

DoCmd.OutputTo acOutputReport, "YourReportName", acFormatRTF, "C:\temp\myreport.rtf"

Search here for emailing documents from access...