I have five subforms each living in a page on a tab control. Each form is
in datasheet view.
The time has come to resize both the forms and the subforms.

I am able to change the column widths in the first subform and these are
remembered. However the column widths for all the other subforms change
back to their original widths when I re-enter the form.

I have no idea why this is and I have checked that all the form properties
are the same.

Any ideas on this?

"Deano" <deano (AT) mailinator (DOT) com> wrote

When you've adjusted the columns, explicitly save the form while it's still
in datasheet view.

"Stuart McCall" <smccall (AT) myunrealbox (DOT) com> wrote

As in clicking the save button? I have tried this. It's really
frustrating. I'm going to dig up an old backup now and see if the behaviour
is still there.

"Deano" <deano (AT) mailinator (DOT) com> wrote

Found out how to do this. Simply open the subform directly and make your
adjustments. Then you're able to explicitly close the form whereas this
doesn't happen when you close it from a parent form.

"Deano" <deano (AT) mailinator (DOT) com> wrote

Well that always works for me.. One thing - are you setting the widths on
the subform opened standalone? If not, give that a try.

"Stuart McCall" <smccall (AT) myunrealbox (DOT) com> wrote

Thanks Stuart, that was indeed the solution.