right-to-left report bug

[papaworx]

I am trying to save a report containing right-to-left text (Hebrew) to a Word (.rtf) file. It works "kind off". Unfortunately, "kind off" isn't good enough: normal phrases are saved correctly, but as soon as the text contains '[', ']', or '.' the word order of the whole phrase is reversed. The letter order within words remains correct. The phrases appear correctly in the report itself, but become scrambled when saving to an (.rtf) file.

[HiTechCoach]

I not had good luck exporting Access reports to a RTF.

I found using Word Automation works much better.

[papaworx]

Yes. I have used Word mail merge as well. But, unfortunately, the same thing happened. It seems that some characters, such as square brackets, don't really exist in the right-to-left set and are intercalated from a left-to-right set. I am still struggling to learn, how the translation of encoding between Access and Word works.

[HiTechCoach]

Yes. I have used Word mail merge as well. But, unfortunately, the same thing happened. It seems that some characters, such as square brackets, don't really exist in the right-to-left set and are intercalated from a left-to-right set. I am still struggling to learn, how the translation of encoding between Access and Word works.

Have you tired automation (not the same as mail merge)?

With automation you work with the Word through VBA code to perform tasks.

Examples:
Fill in Word Forms Using Information Stored in Access
Sending the Current Record to Word 97 with Automation
Word Automation, Part I
Word Automation, Part II
Word-VBA Code Samples

[papaworx]

So I reverted to VBA automation. Didn't help much. A trailing, closing square bracket it still being converted to a leading, opening square bracket.

[papaworx]

I take it back. It does work. All I had to do, was to set "objWord.Selection.ParagraphFormat.ReadingOrde r = wdReadingOrderRtl"

go figure! Thanks for your help

[HiTechCoach]

You're welcome.

Glad I could point you in the right direction.

Great job figuring it out.