right align and listbox control

[wengang]

Hi all.
I think this belongs here in Office rather than Database.

I have a form in Access with a listbox control.
At times, the listbox may be populated with data (values, not bound) that are Arabic.
In those cases, the text should align right to left.

I already have ReadingOrder set to Context, so the text displays in the proper direction (right to left), but it remains Left Justified. For Arabic readers, this is as annoying as would be an English article that was Right Justified.

But as far as I can see, there is no TextAlign property for the Listbox control.

I'm looking for a feasible workaround.

I tried switching to a combobox, which does have text align, but I want to have several rows of data displayed, and with the combobox, stretching it out only makes the dropdown header row taller, not displaying more rows. Is there a setting on the cbox that will make it emulate an lbox? Or any other workaround for this? (seems like a major oversight from MS if not).

Thanks.

[4x2y]

I have Word not Access, as i can see ListBox also has TextAlign property.

Try to set the form's RightToLeft property to True, it may help.

[Ecniv]

Under Format there should be an option for way of reading (I'm reading from a portuguese install here). Not sure it override the columns, never used it...
Its the third option from the bottom of the format list (but you may have already tried this).

Ah i see you have it - reading order. However context picks up the content (I think) so would apply the db rule. Under the file > options > config client there is a default direction option. Try changing that...

[wengang]

my problem with settings changes is that the Arabic text only comes up occasionally. The rest of the time, the alignment should be left justified. Ideally, I need to adjust it programmatically.

[Ecniv]

Ah hmm a bit more difficult in access. I've not done anything like it so if you happen to find the answer, post up - I'd be interested in how you did it.

I think it is difficult because the list box doesnt run on separate lines, just the whole list. May be you you can have a button at the top to adjust the listbox to left to right or visa versa. Not sure it would work.

If the text is a fixed width you might be able to pad the front with spaces.. a poor way of doing it though.

In Word/excel there was a list box control (been a while since I used them) under form controls. you may be able to add a reference ad import that. If so from my vague memories you had control over the cells in the list/table and could allign them as you saw fit (ie for each line set the alignment depending on a field).

Only memories - I may be wrong.