About right-to-left properties

The feature described in this Help topic is only available if support for right-to-left languages is enabled through Microsoft Office Language Settings.

In addition, to enable the right-to-left features in Microsoft Access, you must be running a 32-bit Microsoft Windows operating system that has right-to-left support รน for example, the Arabic version of Microsoft Windows 2000.

The settings for these properties are initially determined when the control is placed on the grid in form or report Design view.

Note   The settings associated with these properties are available for forms and reports. Control behavior for tables and queries is a fixed, bidirectional-capable configuration: ScrollBarAlign = System, NumeralShapes = System, KeyboardLanguage = System, TextAlign = General, ReadingOrder = Context, and initial insertion point position = data dependent. If the control contains no text, then alignment, reading order, and initial insertion point position are determined by the keyboard language when the control is entered: right-to-left if the keyboard language is a right-to-left language, and left-to-right if otherwise.

ReadingOrder property

Determines the reading order of the control. You can specify right-to-left or left-to-right reading order or choose to have the reading order determined by the keyboard language of text first entered.

KeyboardLanguage property

The KeyboardLanguage property overrides the keyboard language that is currently in use (including changing the active keyboard language icon on the taskbar). This property specifies the initial keyboard language when the control receives focus. This feature is useful for volume data entry programs because it reduces the need to make keyboard language changes when moving from one field to the next. You can subsequently choose a new keyboard language.

In Form view or Datasheet view, Access will activate the designated keyboard language. If the operation fails (most likely because the requested keyboard language is not available on the developer or user system), the active keyboard language is not changed.

TextAlign property

This property determines the placement of text within a control. In addition to the standard left, right, and center character alignments, right-to-left features in Access use the General alignment setting to specify how text is aligned.

ScrollBarAlign property

This property allows you to place the control's vertical scroll bars and buttons in the applicable right-to-left or left-to-right direction. To have the scroll bar follow the setting of the Orientation property for the form or report that contains the control, click System. (A vertical scroll bar is placed on the left if the form or report Orientation property setting is Right-to-left; and on the right if the form or report Orientation property setting is Left-to-right.

NumeralShapes property

This property determines if Western (Arabic) or locale-specific shapes will be used to display numeral values.  For example, two different representations of digit shapes are used in number of Arabic countries: Arabic and Hindi. You can choose to have text in controls be specifically Arabic or National (typically Hindi in an Arabic locale), you can let the Microsoft Windows operating system determine the numeral shapes to display, or you can choose to have the numeral shape be determined by the language context of adjacent text (Arabic and Hindi shapes only).