If you have ever typed Thai, Hindi or Vietnamese text in a document or in any text controls in websites, you may have noticed a dotted circle on the screen along with the character that you just typed. Here are examples as shown in the Facebook update status text control and in the Bing Search box:
What is the dotted circle? Why does this happen?
The dotted circle is the character that displays when the order of the characters you typed is incorrect. For example, when an upper vowel is typed after a leading vowel, or a vowel is typed alone without any base character, you will see the dotted circle. If your internet browser doesn't have a typing order rule implemented, the dotted circle may be displayed.
In Microsoft Office, the typing order rule is called Sequence Checking. It allows you to type a valid sequence of independent characters to form valid character clusters. Closely related to this is another rule called Type and Replace. This rule deletes the previous character and replaces it with a new character within the same group of characters. For example, if you enter a vowel that can replace the previous vowel according to the Sequence Checking rule, Type and Replace will delete the previous vowel and replace it with the new vowel.
The Sequence Checking and Type and Replace rules only apply to Thai, Hindi and Vietnamese text.
Most Microsoft Office applications (e.g., Access, Excel, PowerPoint, OneNote, etc.) have Sequence Checking and Type and Replace rules automatically set after setting the default language to Thai, Hindi or Vietnamese. This helps prevent dotted circles from ever appearing in your documents. Some of these applications (Word, Publisher and Outlook) also give you the flexibility to turn these rules on or off to give you full control of how you want your text to look.
As an example, let's walk through how to enable these options for Thai. You must first make sure that you have the Thai language enabled in Office Language Preferences. Go to Start à All Programs à Microsoft Office à Microsoft Office 2010 Tools à Microsoft Office 2010 Language Preferences.
Once the Microsoft Office 2010 Language Preferences dialog appears, under the Choose Editing Languages section:
These steps are really important because the language that you select determines the features available in the application. You can find more information at How To Find My Language Preferences and My Language Preferences: Office Editing Languages.
In Word and Publisher, the Use sequence checking and Type and replace options are located in Options dialog. Go to File menu tab, select Options, and then select Advanced in the Options dialog.
For Outlook, there is an extra step:
To understand more about this, you can do some practice:
Happy Sequence Checking!
can any please let me know whether this option is present for MS Access?
No, there's no option to enable or disable sequence checking in Access because sequence checking is always enabled there.