access 2016 datasheet change column order left-to-right

[ramblon]

Hi,
How do I change datasheet view to display first column on the left?
Tried Options > Client settings > Default direction - left-to-right, but datasheet columns order still appears right-to-left.
Thanks for any help

 

[isladogs]

The initial field order will be what you defined on setting up the DS form.

Change the column order to what you want then save. Close & reopen. The column order is retained

 

[ramblon]

Thanks for this Colin.
I don't want to change the column order. I want the the first column to appear on the left, at the moment the table appears justified right.
Thanks

 

[isladogs]

First of all it sounded like the column order was wrong.
Are you now saying the field 'text' is right justified?
Can you give a screenshot and say what you want changed.

 

[ramblon]

Sorry 1st time trying to post screenshot - can I upload from my pc? or how do I give it a url?
The problem is the selector column (used to select, insert, delete, rows) is on the right - I want it on the left and column order reversed.
Thanks

 

[arnelgp]

do you have Arabic office?

 

[ramblon]

I have Hebrew language support on Windows 10.
and Office 2016 (English) installed.

 

[ramblon]

Ok here's an attached screenshot of the problem.

Thanks

 

[isladogs]

In the form/table property sheet, change the orientation to left to right.
To make this the default for all new datasheets, do the same under default direction in Access options client settings

 

[ramblon]

Thanks Colin, I was looking under File>Options, silly me!