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


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q276594
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

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.

RESOLUTION

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.

STATUS

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

MORE INFORMATION

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.
Modification Type:MajorLast Reviewed:3/27/2001
Keywords:kbbug KB276594
©2002 Microsoft Corporation. All rights reserved.