Results 1 to 4 of 4
  1. #1
    keith2511 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2017
    Location
    UK
    Posts
    45

    Order of columns changes

    Occasionally the order of columns in one of my tables changes when in datasheet view,



    Click image for larger version. 

Name:	datasheet view.png 
Views:	16 
Size:	2.7 KB 
ID:	40177


    even though design view always shows the correct order.

    Click image for larger version. 

Name:	design view.png 
Views:	17 
Size:	8.0 KB 
ID:	40178

    Has anyone experienced this and found a cure?

    Thanks

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    One feature of datasheet view is that individual users can, if they wish, swop the column order. Next time the datasheet is opened that new order is retained.
    So all you need to do is swop the columns back and possibly save.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    keith2511 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2017
    Location
    UK
    Posts
    45
    Thanks for your reply Colin. I am the only user of the database and I do not change the column order. It happened again on Friday and also sorted itself out again after I opened and closed the database a few times. Bizarre and frustrating in equal measures.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Its easy to click on a header & move it possibly by mistake then forget you've done so! At least that's what I always assume when it happens to me
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. order multiple columns in list box
    By Dachbo in forum Forms
    Replies: 2
    Last Post: 07-13-2015, 06:45 PM
  2. How to order columns in ascending order?
    By darkingthereturn in forum Access
    Replies: 5
    Last Post: 06-18-2012, 05:24 AM
  3. Columns change order
    By copaaccess in forum Queries
    Replies: 1
    Last Post: 02-28-2012, 08:52 PM
  4. Report will order/sort 4 columns but not 5. Why?
    By TomHolden in forum Reports
    Replies: 6
    Last Post: 12-17-2011, 04:25 PM
  5. Replies: 0
    Last Post: 06-02-2011, 04:19 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums