By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,681 Members | 1,854 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,681 IT Pros & Developers. It's quick & easy.

A2K - datasheet column width changes not saving

P: n/a
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?
Oct 11 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"Deano" <de***@mailinator.comwrote in message
news:6l************@mid.individual.net...
>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?
When you've adjusted the columns, explicitly save the form while it's still
in datasheet view.
Oct 12 '08 #2

P: n/a

"Stuart McCall" <sm*****@myunrealbox.comwrote in message
news:gc*******************@news.demon.co.uk...
"Deano" <de***@mailinator.comwrote in message
news:6l************@mid.individual.net...
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?

When you've adjusted the columns, explicitly save the form while it's
still
in datasheet view.
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.
Oct 12 '08 #3

P: n/a

"Deano" <de***@mailinator.comwrote in message
news:6l************@mid.individual.net...
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?
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.
Oct 12 '08 #4

P: n/a
"Deano" <de***@mailinator.comwrote in message
news:6l************@mid.individual.net...
>
"Stuart McCall" <sm*****@myunrealbox.comwrote in message
news:gc*******************@news.demon.co.uk...
>"Deano" <de***@mailinator.comwrote in message
news:6l************@mid.individual.net...
>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?

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

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.
Well that always works for me.. One thing - are you setting the widths on
the subform opened standalone? If not, give that a try.
Oct 12 '08 #5

P: n/a

"Stuart McCall" <sm*****@myunrealbox.comwrote in message
news:gc*******************@news.demon.co.uk...
"Deano" <de***@mailinator.comwrote in message

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.

Well that always works for me.. One thing - are you setting the widths on
the subform opened standalone? If not, give that a try.
Thanks Stuart, that was indeed the solution.
Oct 12 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.