Answered by:
VBA Access Arabic problem

-
This really simple, but I haven't found a solution to it so far, and it's screwing all my access programs. It started happening with Access 2007 an on.
Here's the problem.
1. Create a form.
2. Create a label on a form.
3. Edit the OnLoad event of the form.
4. Change the caption of the label: Label0.Caption = "تجربة"
The problem is that I get accented letters in caption when I change it to Arabic. Although I can write in Arabic in VBA, I can't seem to get it to display properly in the form. There seems to be a miscommunication between VBA and Access forms and reports.
Does anyone know how to fix this problem, please?
Question
Answers
-
Hi mqasem,
Welcome.
After installing the language pack, you may follow these steps: From the Control Panel, go to Region and Language. Go to the Administrator tab, click "Change System locale" in the panel "Language for non-Unicode programs", and select Arabic. Refer to the following picture, please:
Hope it helps.
Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.- Marked as answer by Dummy yoyoModerator Wednesday, July 03, 2013 9:23 AM
All replies
-
-
-
-
-
I appreciate your quick response.
1. I'm using the English locale.
2. My Access is English, but I have installed the Arabic Language Pack.
3. I have 2013, 2010 and 2007. All behave exactly the same way.
I'm used to having the English locale and the English Access without these problems. This happened when I got Access 2007 and on.
Thanks
MQ
- Edited by mqasem Sunday, June 23, 2013 4:04 PM Added more info
-
-
-
-
-
You mentioned having A2007, 2010 & 2013.
Does this mean you have all three installed on one machine? If so, Microsoft recommends only having 1 version of software installed at a time as there are version conflicts. This may have something to do with the issue.
Otherwise, can you recreate the issue in a new file rather than just creating a new Form in the same file?
Chris Ward
-
-
Hi mqasem,
Welcome.
After installing the language pack, you may follow these steps: From the Control Panel, go to Region and Language. Go to the Administrator tab, click "Change System locale" in the panel "Language for non-Unicode programs", and select Arabic. Refer to the following picture, please:
Hope it helps.
Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.- Marked as answer by Dummy yoyoModerator Wednesday, July 03, 2013 9:23 AM
-
I thought that changing the locale would change all my settings into Arabic. This was the only thing I didn't try, because I didn't want to change my menus to the Arabic Language. I'm glad it didn't. Problem solved!
Great job!!! Thank you so much. It worked.
MQ
-
I'm glad it helps.
Good day.
Yoyo Jiang[MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help. -