Kevin Roy
My feedback
-
90 votes
Note that typically the reason this happens is that there is code behind the datasheet form that modifies properties on the form or controls (e.g. Textbox.Locked). Access intends to save the datasheet column widths without saving the properties changed in code, and that process was not working as expected. We are planning to fix this, but in the meantime, you may be able to work around this if you can avoid changing form/control properties in code (e.g. by using Conditional Formatting instead)
An error occurred while saving the comment
After I've rearranged and re-sized columns in an Access Form data sheet view, I do the following to make the changes stick: right-click any column header; select "Hide column" from the context menu; right-click any other column header; click "Unhide Columns", then check the unchecked column that you had previously hidden. This apparently forces Access to remember the column order and column widths.