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

How to detect if column widths have been changed in Access datasheet

P: n/a
Hi. I have an Access database with a form containing 4 datasheets and I
allow the user to change column widths. On closing the form, a routine
is fired that saves each column width to an INI file.

When the form is opened, the INI file is read and sets up the column
widths for the user.

Works well, but there is a slight delay on closing the form, so I would
like to detect if any column widths have been changed and save them
only if they have been changed. There is no
OnDatasheetColumnWidthChange event that I know of. Anybody got any

My only idea so far is to add up the total of all column widths on
opening the form, store this number and compare it to the total of all
column widths before closing the form - if there is a difference then I
would save the column widths.

Dec 21 '06 #1
Share this Question
Share on Google+
2 Replies

P: n/a
Are you trying to save the column width's for each user? Or just save the
column widths as they were last saved by any user? The reason I ask is, when
I change widths on a datasheet form, the changes are automatically saved and
return when the form is opened again.

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via

Dec 21 '06 #2

P: n/a

Since he is saving it in an INI file it is probably for each user. I do
the same but I use a table keyed by user and form name and a record for
each field involved.

As to the question, I can't think of any easier way. Chances of them
changing sizes on two columns and offset each other are extremely


Dec 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.