Saving rearranged columns in a datasheet form

[dantebothermy]

My users and I use Access 2003.

We've got a subform in datasheet format. How do I, how do my users save the layout after re-arranging columns?

Thanks

[kstevens]

Once they are rearranged will they stay that way, or will each person have there own arrangement?

[dantebothermy]

I'd prefer that each person can have her own arrangement, but I'd be happy to just be able to change the master copy with different arrangements.

[kstevens]

Forms!FormName!NameOfControl1.ColumnOrder = 1
Forms!FormName!NameOfControl2.ColumnOrder = 2

Put this in the onload event. If you wanted it done different for different peiple then you would have to verify who was loggining in and set these differently for each person...
Also, you can hide the coluns progamatically with

Me.Controls("NameOfControl").ColumnHidden = True