Results 1 to 3 of 3
  1. #1
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    Columns move of their own accord

    I think the database I created is possessed.



    It's something new; its happened once last week and twice this week, these field columns that have moved of their own accord when I open the table. I've moved them and saved the table after each time, but it is still happening.

    Here's the design view:
    Click image for larger version. 

Name:	Table Design.png 
Views:	14 
Size:	10.5 KB 
ID:	28066

    And here's the datasheet view:
    Click image for larger version. 

Name:	Table Design 2.png 
Views:	14 
Size:	40.4 KB 
ID:	28067

    Anyone having an idea on how to fix this, please let me know. In the meantime, I'll be looking into performing an exorcism (anybody know a priest? I'm Jewish).

    Thank you,

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Thank you - I needed a good laugh!

  3. #3
    jwhite is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Dec 2012
    Location
    North Carolina
    Posts
    349
    Does anyone else have access to this table and ability to open in DataSheet View? If fields are moved around by the user, on close of the view Access will prompt to save the new layout. This is independent of the design order of the fields.

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

Similar Threads

  1. Disable the ability to move columns in a query?
    By dhaugland in forum Queries
    Replies: 6
    Last Post: 12-17-2015, 03:49 PM
  2. Replies: 3
    Last Post: 12-11-2014, 11:26 AM
  3. Dynamic Columns - Import new columns?
    By memaxt in forum Import/Export Data
    Replies: 2
    Last Post: 06-24-2014, 06:02 AM
  4. data columns (fields) in table will not move
    By wolfm in forum Database Design
    Replies: 6
    Last Post: 05-15-2014, 10:01 AM
  5. Using a query to move data to new columns
    By emunson in forum Queries
    Replies: 2
    Last Post: 12-01-2010, 10:16 PM

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