This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have 4 columns in my access split form e.g. columns A, B, C, D. I like to keep them in the same order, but on opening the form the order of the columns is changed to e.g. B, D ,A, C. I could not find any reason for this nor system. In viewmode the order of the columns can be rearranged. With the right mouse button the order can be fixed. But everytime I open the form I run into the same problem. How can I fix the order?
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Strange seemed to work for me, what year is your Access?
You could rearrange the columns in the table that is linked to the form, but that may cause problems elsewhere.
It seems to work if you save after you made the layout change, I don't think it saves the layout if you just close it down.
I just rearranged the columns and saved (Ctrl + S) then closed and opened the form and it was was in the right layout.
Hello Deadshunt,
I tried your suggestion with Ctrl + S.
Unfortunately this did not help.
I think this has the same effect as the Save function of the quick menu on top of the screen which I used. So there must be another reason why the columnsorder is scrambled during opening the form. I have no reason what that could be. The form is useless if the columns are not in the right order. Any suggestion is welcome.
It seems to work if you save after you made the layout change, I don't think it saves the layout if you just close it down.
I just rearranged the columns and saved (Ctrl + S) then closed and opened the form and it was was in the right layout.
Are you talking about the tab order? or the layout in Datasheet view?
I do not think it has anything to do with the tab order.
I am having difficulty in my split form to fix the order of the columns in a specific way . Everytime I arrange these columns in a certain way, they are mixed up again after I reopen the form (in view mode). I think you can only change the order in view mode. That is what I did. After that I saved the form befor closing it. Whatever I tried so far no luck.
Are you talking about the tab order? or the layout in Datasheet view?