When opening a SharePoint list in Access, how do I set the order that the columns are displayed by default?
Category: sharepoint 2010 general
Question
mrthetooth on Thu, 27 Sep 2012 22:47:00
On a SharePoint list, when clicking Open with Access, how do you change the order that the columns are displayed by default?
I can easily change the order of the columns locally once I've opened Access, but I want to change the order that the columns are displayed in by default after users click Open with Access.
I tried changing the Column ordering under List Settings, but that didn't seem to do it.
Replies
Venkatzeus on Sat, 29 Sep 2012 07:03:51
HI,
In List settings, Views section - create view - Select the "Access View" and set the order of columns.
Hope this helps.
Thank you
mrthetooth on Wed, 10 Oct 2012 18:35:43
I appreciate the suggestion, but that method seems to just open access so I can create forms or local views. I'm looking for a way to change to default order of columns when users click the Open with Access button.
Venkatzeus on Thu, 11 Oct 2012 06:45:48
Hi,
I understand that you are trying the change the default order of columns. There is an option, but i think this will get updated across irrespective of the access or list.
To change the order of columns:
- Go to List settings
- Select Advanced settings
- Click Yes for “Allow management of content types” and then click OK.
- From the list of content types, select the content type the column appears in, e.g. “Item”.
- There you can find the option to change the column ordering.
Please note: This would be a common change, not just for access.
Hope this helps
mrthetooth on Thu, 11 Oct 2012 22:57:12
Thanks, but while that method is one way to edit the default order of columns in a standard view, it doesn't seem to edit the order of columns when using the Open with Access option.