pdvsa
asked on
Form in Datasheet View, Column widths dont save
Experts,
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
pdvsa,
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)
;-)
JeffCoachman
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)
;-)
JeffCoachman
ASKER
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
thank you
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...
JeffCoachman
(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...
JeffCoachman
ASKER
ok thank you. It seems MX is a anti-corruption specialist. He usualy answers those types of questions. ttyl...
ASKER