ACC2000: Text Is Truncated or Misaligned in Right-to-Left Labels

Text in a right-to-left label in an Access report is misaligned at the right edge. Letters at the right edge of the text may be completely missing.

To work around this behavior, use one of the following methods:

• Export the report in RTF format, and then open the RTF file in Word.
  
  For more information about how to export a report in RTF format, click Microsoft Access Help on the Help menu, type Export data or database objects to another database or file format in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
  
  
  NOTE: RTF files can get very large when the report contains a lot of data.
• Split up the label text into several one-line labels and arrange these so that you achieve the desired layout. Make sure that you check in print preview whether the label texts are correctly aligned vertically, and modify the horizontal position of the labels slightly if necessary.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Steps to Reproduce the Behavior

1. Install Access 2000 on an operating system that allows right-to-left writing, for example, the Arabic or Hebrew versions of Microsoft Windows NT 4.0 or Microsoft Windows 2000 on which language support for a right-to-left language is enabled.
2. In Microsoft Office 2000, activate language support for the same right-to-left language that is enabled in the operating system, for example, Arabic or Hebrew.
3. Start Access 2000.
4. Create a new database.
5. Create a new table, and then type some data.
6. Create a report that is based on this data.
7. Open the report in Design view.
8. Add a label to the report
9. In the label, type at least two lines of text in the right-to-left language that you activated in step 2.
10. On the View menu, click Properties. In the label properties, click Text Align: Right. Set the ReadingOrder property to either Right-to-Left or Context.
11. On the View menu, click Print Preview.

Note that the text is misaligned at the right side of the label. In addition, letters may be missing.