Saving DataSheet Changes in MDE

[Milan]

Hello,

I have the following problem. Is it somehow possible to save format
changes (especially change of column order or column width) of
datasheets in MDE? In MDB all the format changes are saved
automatically but in MDE not.

Many thanks for your help!

Milan

 

[Allen Browne]

You cannot save any design changes in an MDE.

However, datasheets have properties you can manipulate programmatically,
including the widths of the columns, ColumHidden, and so on. It is possible
to save all the settings into a table in Form_Unload, and then read them
back and apply them in Form_Open next time the user opens the form.

IME, though, if you give users that kind of power they get themselves into
trouble, e.g. "My column disappeared".