Export to RTF

[vix666]

I have a report which is exported to RTF format. But when I do this my memo field gets split up, as the report is 2 pages long, but instead of the rest of the memo field appearing at the top of the page it starts half way down.
I would use a Snapshot but i need the file to be editable.
Any ideas how to solve this would be much appreciated.

Thanks In Advance

Vicky

 

[hermanlaksko]

Why not use excel format ?

Herman

 

[vix666]

I have mentioned that to them, but they are insistent on using MS Word, which just makes things awkward.

Vicky

 

[hermanlaksko]

Word does read excel files .... if excell is installed.

Herman

 

[vix666]

Do you mean transfer the data into excel and then into word?

I now know why the text is cut in to 2, its because of carriage returns, i now need some code that will delete the returns in the memo field when it opens the report.
Any ideas what I could use? I have access 97.?

Thanks for your help

 

[hermanlaksko]

Yes - however the excel format will still be there i.e. word will show an excel worksheet inside the word doc.

the ascii code for a cr/returs is chr(13) or chr(10) I think that 13 is the actual return and the 10 is the linefeed.

Herman