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.


Venkatzeus on Sat, 29 Sep 2012 07:03:51


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


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.