hello, keeping column width in datasheet

[tom taol]

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, open the form again...
the width of the form is not keep....

I want to apply column widths of a form lately.

*** Sent via Developersdex http://www.developersdex.com ***

[Ron2006]

The fixed/forced method is perhaps the most fool proof.

I have found through trial and error, if there are multiple datasheets
on a single form, if I change the column sizes on 1 datasheet and then
close the form, and then open it and change the next datasheet, etc.
it will keep the sizes.

The key is to do only one datasheet subform at a time and save the
entire form in between.

I have two applications that are used by multiple users with a lot of
columns. I created a table, by user/ form / column name and saved the
sequence and width of each column. (When they press a button on the
form, the program goes through and rearranges and re-sizes each.
Another buttom allows them to rearrange the columns and when they
press the second buttton I save what they have arranged. Works like a
charm, but did take some work setting up. But in our case it was well
worth it.

Ron