Last active
October 26, 2023 14:45
-
-
Save NPS-ARCN-CAKN/5ecec709fb133b10b725 to your computer and use it in GitHub Desktop.
Microsoft Access 2010 fix for datasheet view column order not persisting with save
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| I encountered a bug in Microsoft Access 2010 where I would open a form in split view or datasheet view, | |
| rearrange the order of columns, save the form, re-open the form and the column order would not reflect | |
| the columns order I had tried to save. | |
| Solution: | |
| 1. Open the form in datasheet view | |
| 2. Re-order the columns | |
| 3. Right-click a column header and click Unhide fields | |
| 4. Close the Unhide fields dialog | |
| 5. Save the form and re-open | |
| I can't guarantee this will always work but it solved the problem for me once. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I had tried correcting this issue the correct GUI way and programatically - no such luck. Stumbled onto this solution and it solved the issue.
Applicable to: Access 2016 > Forms > Datasheet View