Tips and Tricks by The Wizard
5 Access Settings for the Right-to-Left Languages
Hello My Apprentice,
Welcome back! As you might know already, Access is a popular database software application. It has rich support for international features such as date, time formatting, calendar, currency and text editing, etc. Today, I will shed some light on the features that are designed for the users of a Right-to-Left language.
1. Right-to-Left Default Direction
If the language of your Microsoft Office is not one of the Right-to-Left language versions, you’ll probably see the layout of objects like tables, forms and reports in the Left-to-Right direction. You can go to the Access Options dialog to switch the direction of these objects. Here are the steps: click the File button –> Options -> Client Settings tab –> under the Editing section, find Default direction -> select the Right-to-left radio button –> OK.
Once the “Right-to-Left” setting is applied, the next time you create a new database, the Right-to-Left layout will be used by default for objects such as tables, forms and reports. As shown in the snapshot below, the first column of the table starts from the right. The location of the fields and the controls in the form and report are also on the right and the text is right aligned.
Can I switch the direction of the new object in my current database?
The answer is: It depends.
2. The Hijri Calendar
The current Islamic year or Hijri calendar year is 1430 (while the Gregorian calendar year is 2009). By default, date format used in any Date & Time field follows the format of the language set in the Windows Regional and Language Options. For example, if the Regional language is set to English, then the Gregorian calendar will be used in Access.
If you want to leave the Windows Regional language as English while having the ability to use the Hijri calendar in the database, you can do this in the Access Options dialog. Here are the steps: click the File button –> Options -> Client Settings tab –> under the Editing section, check the “Use Hijri Calendar” checkbox –> OK.
Note that this checkbox will only be enabled after a database has already been created.
Once this setting is applied, all existing dates in the table will be automatically converted to the Hijri calendar format. For example Gregorian calendar date 1/1/2009, will be converted to Hijri calendar format as: 1/5/1430. And, all new dates entered will automatically use the Hijri calendar format.
The “Use Hijir Calendar” setting is saved along with the database. To use this setting for any new database, it needs to be set each time for each database.
3. Using the Hindi Numerals
Hindi numerals can not be typed directly from any Right-to-Left language keyboard. To enter the Hindi numerals in Access, you can do the following in the Regional and Language Options of Windows:
Click on the Formats tab
Choose a Right-to-Left language under Current format. In this example, I am using Arabic (Saudi Arabia).
Click on Customize this format… button
Select Context from the Use native digits dropdown (this option is usually set by default for the Arabic language).
Note that the screenshots above are taken from Windows Server 2008. This dialogs could be slightly different in Windows XP and Windows 7.
Now, in Access tables, the Hindi numerals will be used for numbers typed after Arabic text.
For the Access forms, one more setting needs to be set to get the Hindi number. In the Form Layout View, select at any editing control –> right click and select Properties –> in the Property Sheet Pane, click on the Format Tab, scroll all the way down until you see “Numeral Shapes” –> select the “System” as the option –> switch back to the Form View mode.
4. Right to Left Reading Order
Sometimes when working in the Form or Report view, especially in the Text field, it could be a little confusing if the user enters the text that’s mixed with Left-to-Right and Right-to-Left languages, for example English and Arabic.
To avoid this confusion, you can explicitly set the reading order of the field. In the Form Layout View, Right click at any Text field –> choose Property –> in the Property Sheet Pane, click on the Format Tab -> scroll down to “Reading Order” -> select “Left-to-Right”, “Right-to-Left” or “Context”.
In the snapshot below, you can see the difference of the reading order when the text field is set to “Right-to-Left” v.s. “Left-to-Right”. The sample text is typed in the same order - from left to right as Hello Reader ?????
If the Reading Order is set to “Context”, the reading order will follow the first language typed into the field.
5. Cursor movement
In the Access Options dialog, under Client Settings, Editing section there is one more setting that is specific to the Right-to-Left languages: Cursor movement. Users can use it to set the direction of the cursor when they move the cursor among any Right-to-Left or non Right-to-Left text.
Visual Cursor movement - The cursor will move in the same direction as the characters shown on the screen
Logical Cursor movement -The cursor will move in the same direction as the typed bidirectional text.
Once this setting is applied, it will apply to all the objects and any editing controls throughout the database, including the new databases.
Alas, that is enough wisdom for today. Practice this well, and next time, I shall show you more tips and tricks.
If you have questions or comment, leave a note below and I shall respond.
Oh, I must give credit to one of my apprentices, Sirirat Reinikka for assisting me in gathering this information for you. Sirirat works with the Office Global Experience Platform team as a Software Development Engineer in Test at Microsoft. Sirirat is originally from Thailand but she and her team work in Redmond, Washington, USA. Sirirat and her team specifically focus on making sure the Office applications are ‘world-ready’! Assisting Sirirat with this article is her teammate Reda Elkhadiri, and her co-worker Aleksandar Jaksic in the Access team.
The example companies, organizations, products, domain names, email addresses, logos, people and events depicted herein are fictitious. No association with any real company, organization, product, domain name, e-mail address, logo, person, or event is intended or should be inferred.