Anonymous
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
Amazing this is still an issue. I have always been able to just reposition the columns and save and it is fine. Now that ability has been changed and doesn't work. yep lots of code in my forms but nothing that messes with the form controls, only data. This has gone backwards and relates to the fundamental user interface design that access is and was so good at. None of the workarounds above have worked for me at all.
If it cannot be resolved after 5 years then the advantage that access provides is gone and going to a different interface is not an option for some applications.