473,387 Members | 1,592 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

A2K - datasheet column width changes not saving

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
5 10998
"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

"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

"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
"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

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Arnie | last post by:
I have searched this NG for datasheet column width posts and have read many of them. None of them seem to address what I would like to do. I'm beginning to think what I want can't be done. Here...
0
by: Lalit Bhatia | last post by:
Hi, In Datagrid, while setting width of column through GridColumnStyles collection. width does not set to exact width that I am setting in my code. If I set width to 13, it is changed to 130 or...
18
by: chimalus | last post by:
I am using a table with no column widths specified, letting the table layout manager do its thing for figuring out the column widths, and this works just fine. Now I want to make the table...
1
by: msch-prv | last post by:
I have difficulties adjusting the column width of a gridview control. The column width changes appear in the design grid, but at run-time the width changes back to what I presume are the grid's...
1
by: DBC User | last post by:
I would like to trap an event, when someone changes the column width on a datagridview. I tried all the (almost) event with width in it and none of them are firing when I change the column width....
2
by: Arash | last post by:
Is it possible to autofit column width in Access using vba? Something like the following in Excel: Worksheets("Sheet1").Columns("A:I").AutoFit Thanks in advance,
1
by: tom taol | last post by:
Currently, there are 3 datasheets in a form. and, i changed column widths of each form(datasheet type) by the way, there is not keep the column width in ms access. for example, i close the form,...
1
by: asearle | last post by:
Hi everyone, I have a table which, in order to line up with other information, needs to have very exact column widths. So far I have implemented the following with normal HTML tables ... <td...
2
by: Deekay | last post by:
Help !! My code below generates error 425 'object required'. (I'm using Access 2003) I have a table opened as a datasheet, but the column widths need adjusting programatically to fit. I have seen...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.