Tab Indexing

[xzyrex]

Hello Guys
I and developing a small access Database for a payment processing
The Challenges I face is when it comes to Language Problem, unlike most of you guys up there, we have different language which require Right to Left index

I was able to move the index using the a code below

If OfficeNameDhivehi.SelStart = 0 Then
Exit Sub
Else
' OfficeNameDhivehi.SelStart = OfficeNameDhivehi.SelStart - 1

End If

But the Problem is when it comes to multi-line texting in text fields... the thing is when i enter a long text the first life goes the last and the last time comes on top

Could any one help me to solve this problem using a code?
Our language is like Arabic

 

[gemma-the-husky]

you can set the tab order of text boxes etc, to suit - so although they would by default by left to right, you can reset them to whatever you want.

there may be an automatic right ot left option, but im not sure

 

[xzyrex]

Well i can set that but the thing is that when it comes to multi line text

For Example i want write in the text box using our lenguages " you are the greates man in the world to whom we all respect"

if i set the text box language English it appears like this

"You are the greates man in the world
to whom we all repect"

but if i set it in our local languges which is writting in right to left if appears like this

"to whom we all respect
you are the greated man in the world"

the bottom part is on top and top is in bottom

 

[gemma-the-husky]

isn't that curious? - i can see why it might wrap in that way (its obviously reversing the whole string, which isnt the right way to do it, for multi-line text), although i doubt if word, say, does the same thing- i don't have any experience in right to left languages, so i am not sure how to help in Access - sorry

 

[nIGHTmAYOR]

xzy this problem happens even in Arabic
however the problem doesnt happen on data retrieval nore texts bound to a control source but only on design view of both forms and reports. The faster and less hassel way to solve it is to type the text you want to insert in your control in note pad then copy/paste it to your control . If not you can also use vba to assign values as in :
Me.TextBox0 = "أهلا"
Finaly if you want to go through the hassel try changeing your regional settings (Control Panel >> Regional And Language Settings) to other regions useing right to left (Suggesting Saudia Arabia for a start) and move along till you find it fixed.