Form in Datasheet View, Column widths dont save


I have a form
Data sheet view (Default view)
I open form, resize the column widths, save

but the columns widths dont save.  I have attempted many times and have moved fields around on the detail section so that when I close, the form asks me if I want to save changes.

How can I set / change the column widths and keep that new setting?
pdvsaProject financeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
This works fine for me, both a datasheet view form and the raw table...

Is this for all datasheet view forms?
If it is only one form that has this issue, then the easiest thing to try would be to delete the form, then recreate it...

If not, try the usual:
run the compact/Repair utility
Complie the code
run the compact/Repair utility again.
Then test for this issue.

If it still persists, create a new blank database and import all the objects
Then test for this issue.

At the extreme end you can decompile the database:


There may very well be a simple fix here that I am just missing, lets see what other experts post.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pdvsaProject financeAuthor Commented:
The form was corrupted.  thank you
Jeffrey CoachmanMIS LiasonCommented:

Just a few notes here as I know you are a regular member here and you post a lot of good questions...

Why a form gets corrupt is a tough question to answer.
The best defense is to run the compact repair utility *after editing each object*

So C&R is not something I do one a week or once for the database.

I pretty much do it instead of saving. (because C&R will ask you if you want to save anyway...)
So I might run it 8 times while editing an object (again, just substituting regular saves for just running C&R

Ok, if C&R takes 30 seconds to run (on a large DB, sure I will perhaps do it after I edit each object..

The same goes for compiling he code...
I do it after editing each sub...

In other words, if I modify the design of 4 objects in the DB, I will run C&R 4 times.
If I modify 7 subs, then I compile the code 7 times.

Luckily your form was easy to recreate, but with more complex forms, recreating them can be brutal... (if you don't have a backup)


Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

pdvsaProject financeAuthor Commented:
oh I did not know C&R was that important to run after each edit.  I will start doing this though i/o saving like you mentioned.  

thank you
Jeffrey CoachmanMIS LiasonCommented:
You don't "Have" to do it after each edit, that is just what I do.
(perhaps I am a bit paranoid...)

At a minimum, do it after each session of editing of the db.
Better would be once for each edit object...
Beyond that, it is up to you...BTW I got this advice from DatabaseMX, and it is rare that I have object corruption anymore...

pdvsaProject financeAuthor Commented:
ok thank you.  It seems MX is a anti-corruption specialist.  He usualy answers those types of questions.  ttyl...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.