Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-27-2019, 12:17 AM   #1
ramblon
Newly Registered User
 
Join Date: Oct 2019
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
ramblon is on a distinguished road
access 2016 datasheet change column order left-to-right

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


Last edited by ramblon; 10-27-2019 at 12:18 AM. Reason: just checking
ramblon is offline   Reply With Quote
Old 10-27-2019, 12:26 AM   #2
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,326
Thanks: 115
Thanked 3,101 Times in 2,819 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: access 2016 datasheet change column order left-to-right

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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 10-27-2019, 12:37 AM   #3
ramblon
Newly Registered User
 
Join Date: Oct 2019
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
ramblon is on a distinguished road
Re: access 2016 datasheet change column order left-to-right

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

ramblon is offline   Reply With Quote
Old 10-27-2019, 12:50 AM   #4
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,326
Thanks: 115
Thanked 3,101 Times in 2,819 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: access 2016 datasheet change column order left-to-right

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.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
Old 10-27-2019, 01:07 AM   #5
ramblon
Newly Registered User
 
Join Date: Oct 2019
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
ramblon is on a distinguished road
Re: access 2016 datasheet change column order left-to-right

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
ramblon is offline   Reply With Quote
Old 10-27-2019, 01:09 AM   #6
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,569
Thanks: 68
Thanked 2,745 Times in 2,630 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: access 2016 datasheet change column order left-to-right

do you have Arabic office?
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 10-27-2019, 01:30 AM   #7
ramblon
Newly Registered User
 
Join Date: Oct 2019
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
ramblon is on a distinguished road
Re: access 2016 datasheet change column order left-to-right

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

ramblon is offline   Reply With Quote
Old 10-27-2019, 01:48 AM   #8
ramblon
Newly Registered User
 
Join Date: Oct 2019
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
ramblon is on a distinguished road
Re: access 2016 datasheet change column order left-to-right

Ok here's an attached screenshot of the problem.

Thanks
Attached Images
File Type: jpg datasheet.jpg (98.1 KB, 17 views)
ramblon is offline   Reply With Quote
Old 10-27-2019, 02:59 AM   #9
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,326
Thanks: 115
Thanked 3,101 Times in 2,819 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: access 2016 datasheet change column order left-to-right

In the format tab of the form 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
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Common sense and a sense of humour are the same thing, moving at different speeds. (Clive James - RIP)
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
ramblon (10-27-2019)
Old 10-27-2019, 03:26 AM   #10
ramblon
Newly Registered User
 
Join Date: Oct 2019
Posts: 10
Thanks: 2
Thanked 0 Times in 0 Posts
ramblon is on a distinguished road
Re: access 2016 datasheet change column order left-to-right

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

ramblon is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing the column order in the datasheet portion of a split form (Access 2010) R_J_Potter@msn.com Forms 13 05-13-2019 03:19 PM
Datasheet column order not saving!! cheese Forms 7 02-08-2014 05:34 PM
Column Order in a datasheet form MarionD Forms 4 01-15-2011 05:36 AM
Changing the column order in the datasheet part of a split form (Access 2007) Kafrin Forms 4 12-03-2009 04:09 AM
Dynamically set column order on datasheet boblarson Forms 6 08-10-2007 07:41 PM




All times are GMT -8. The time now is 08:19 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World