Datasheet View: Save Column Position

[JamesHalko]

Hello All,

I have a datasheet form that I would like to change the column order of. However, I have noticed that when I do change the order, said changes are not saved. Is there anyway to save the column order for a datasheet?

Thank you so much, I greatly appreciate any/all responses.

[jforbes]

If you open the Form in DataSheet View and move some columns around and then Exit the Form, the Column order doesn't always get saved. I've never figured out why this doesn't always happened, but usually makeing a change to the Form itself at the same time, even if it is just to move a control and then move it right back again, will cause the changes to be saved.

Also there is the fun situation where every user in the system is moving columns around because they all have different needs. Causing the order of Columns to be different every time the Form is opened. If you want to hit this problem with a Big Hammer, you can use some code like the following to override "Access' Magic Column Configurator" and set the order yourself:

Private Sub Form_Load()
    Me.txtSelectRow.ColumnOrder = 1
    Me.txtFileName.ColumnOrder = 2
    Me.txtDirectory.ColumnOrder = 3
End Sub