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

hello, keeping column width in datasheet

P: n/a


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 ***
Jun 25 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Jun 26 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.