Fix saving column order in datasheet view
I have noticed this issue whereby you move columns and when the user exits the form, the datasheet columns revert back to the original (pre-saved) order. The work around I found was to hide/show columns, toggle one field on then off, close dialogue and then it will save. Not very intuitive.
Thanks for fixing.
To clarify, this happens when using datasheet subforms on a main form.
Users need to be able to control the datasheet columns as they usually unique to each person.
Yes this behavior seems to have changed circa A2010, or at best inconsistent. In the past, you could set the ColumnOrder in Datasheet view - then File>>Save ... and the next time you open the Datasheet - that would be retained. However, this rarely seems to work now.
So, my workaround is in VBA in the Form Load event to set the ColumnOrder property for a given text box, which always works, but a bit of a hassle.