Fix: runtime error 7771 when using VBA ColumnOrder in MS Access 2016
I am trying to arrange datasheet columns for users, when a form loads. I have code (in a module) that sets the "ColumnOrder" property, using the OnLoad trigger for the form.
I receive the runtime error '7771':
"You can't set the ColumnOrder property when you are in Form view or PrintPreview."
I'm also updating ColumnHidden, and ColumnWidth, using data saved in a table, so that users can save their datasheet view settings and have them regardless of which desktop they're working on. This is an access front end, linked to a SQL server storage.