By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,439 Members | 1,330 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,439 IT Pros & Developers. It's quick & easy.

Datasheet View: Save Column Position

P: 21
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.
May 21 '15 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,107
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:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()
  2.     Me.txtSelectRow.ColumnOrder = 1
  3.     Me.txtFileName.ColumnOrder = 2
  4.     Me.txtDirectory.ColumnOrder = 3
  5. End Sub
May 21 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.