hairwormman
Programmer
I have noticed that many people are having the same problem as I, but this forum has not been able to provide an answer. Thus I suspect that this is a flaw in Access, but let me give this question one more try (thanks for your patience!!).
When looking at a report in Access 2002, the text looks perfect: layout is good, spacing is as wanted, the text is all there. However, when you export this report to rtf or txt format (including MSWord),the text is different. Now different is not always bad, but different here is that the content is fundamentally changed. This includes the insertion of spaces, deletion of complete lines (either directly after a page break or anywhere within a page (this line of text is replaces by a blank line)), partial transfer of memo fields (where only 50 to 100 characters of 500 are copied, followed by blank lines where the text should be), and many other anomalies.
The main answer that I have read in this forum has been to use a snapshot viewer. This works great if this file is to be read only, but if you have to have an editable file this will not work. For my work, I must send a text formatted report to an automated web server, which parses out certain info. However, since the conversion often changes the content of the report the server returns the whole mess, and I have to spend hours making the word file look like the report in Access. What a waste of time!
Is there anything out there that will fix this problem? I have tried to contact MS regarding this issue, but it seems that I get the run around (they tell me "check your code" or "reinstall Office" or "it must be your hardware", etc.). I have done all of this, but after reading that dozens of similar posts exitst on this forum, it cannot be me. Does anyone have a suggestion of how to get in touch with a tech directly, to get Microsoft to write a patch for this problem?
Thanks to all of you for reading this and responding.
Cheers...Ben
When looking at a report in Access 2002, the text looks perfect: layout is good, spacing is as wanted, the text is all there. However, when you export this report to rtf or txt format (including MSWord),the text is different. Now different is not always bad, but different here is that the content is fundamentally changed. This includes the insertion of spaces, deletion of complete lines (either directly after a page break or anywhere within a page (this line of text is replaces by a blank line)), partial transfer of memo fields (where only 50 to 100 characters of 500 are copied, followed by blank lines where the text should be), and many other anomalies.
The main answer that I have read in this forum has been to use a snapshot viewer. This works great if this file is to be read only, but if you have to have an editable file this will not work. For my work, I must send a text formatted report to an automated web server, which parses out certain info. However, since the conversion often changes the content of the report the server returns the whole mess, and I have to spend hours making the word file look like the report in Access. What a waste of time!
Is there anything out there that will fix this problem? I have tried to contact MS regarding this issue, but it seems that I get the run around (they tell me "check your code" or "reinstall Office" or "it must be your hardware", etc.). I have done all of this, but after reading that dozens of similar posts exitst on this forum, it cannot be me. Does anyone have a suggestion of how to get in touch with a tech directly, to get Microsoft to write a patch for this problem?
Thanks to all of you for reading this and responding.
Cheers...Ben