Results 1 to 4 of 4

Order of columns changes

  1. #1
    keith2511 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2017
    Location
    UK
    Posts
    35

    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 Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,839
    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 (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    keith2511 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2017
    Location
    UK
    Posts
    35
    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 Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,839
    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 (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

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
  •  
Tech Forums: Microsoft Office Forums