Wednesday, March 16, 2022

I Know There Are Access Experts Out There

 One of the columns in the datasheet view has inexplicably moved from column 20 or so to column 2.  I want it back in column 20.  I would expect column number to be a property of the column.  But where is that property?


  1. I do believe that the column order in the dataset view is determined by the order of the SQL statement. Check the SQL view.

    1. SQL View? The table has a design view but not an SQL View. This is not a query.

  2. You can rearrange Access column position by selecting, then drag/drop. You may have accidently done that to cause the current configuration and can deliberately do it to get the wayward column back where you want it.

  3. Weird. I reopened it and everything is where it was before.