In a new access 2010 form with a lot of controls, most formatting changes I make are undone next time I open the form. And yes, I did save it.
On the off chance that I had reached some type of control number limit, especially after renaming most of them a few times, I copied the controls to a new form. Still the same problem.
Any clues?
Formatting doesn't stick.
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Formatting doesn't stick.
Avagr8day, regards, Peter
-
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formatting doesn't stick.
Have you tried Database Tools > Compact and Repair Database?
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Formatting doesn't stick.
Yep a couple of times. Didn't work.
Maybe a repair of Access?
Maybe a repair of Access?
Avagr8day, regards, Peter
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
-
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formatting doesn't stick.
Try creating a new empty database. Then import all database objects from the problem database into the new one.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Formatting doesn't stick.
A LOT of objects. Main prob is the relationships rebuilding. Haven't done that since I ditched replication. A lot hours for this Db. Too hard.
Avagr8day, regards, Peter
-
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Formatting doesn't stick.
There are options to select all objects of a type (Tables, Queries...) etc. in one go, and to import relationships too.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Formatting doesn't stick.
thanks Hans. That sounds easier. Will give it a go.
Avagr8day, regards, Peter
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Formatting doesn't stick.
Well I'll be!
Took me less than 2 minutes. When I think of the countess hours spent rebuilding databases that replication messed up - grrrr. Boy, would that have saved me a heap of time - 4 hours at a min each time. And replication ended up messing my Db about once a fortnight.
One thing that the process misses is 'References'. I had to rebuild them. That took a lot longer than the importing.
Oh, and that form now keeps any alterations. WHOOPPEE!
Took me less than 2 minutes. When I think of the countess hours spent rebuilding databases that replication messed up - grrrr. Boy, would that have saved me a heap of time - 4 hours at a min each time. And replication ended up messing my Db about once a fortnight.
One thing that the process misses is 'References'. I had to rebuild them. That took a lot longer than the importing.
Oh, and that form now keeps any alterations. WHOOPPEE!
You do not have the required permissions to view the files attached to this post.
Avagr8day, regards, Peter
-
- 5StarLounger
- Posts: 962
- Joined: 09 Feb 2010, 00:33
- Location: Patterson Lakes, Victoria, Australia
Re: Formatting doesn't stick.
Oh what a journey.
The copying all Db elements seemed to allow the faulty form to work. That is until I tried to do more than superficial changes - then the changes, once again, didn't stick. On top of that, the Db then had numerous faults - vba code couldn't find text boxes that were clearly there and numerous other mess ups. I decompiled, but that made no diff. In the end I had to go back to the original Db - but, as I was aware, the form didn't work. Then I found the problem; Calibri font was causing all the angst. I remove all traces of Calibri replacing with Arial and everything worked beautifully. Can't see how that is possible, but the form has been working for over a week now.
I am guessing that removing Calibri from the computer and installing a new version will result in that font working on the form. If anyone else has any feedback, let me know.
The copying all Db elements seemed to allow the faulty form to work. That is until I tried to do more than superficial changes - then the changes, once again, didn't stick. On top of that, the Db then had numerous faults - vba code couldn't find text boxes that were clearly there and numerous other mess ups. I decompiled, but that made no diff. In the end I had to go back to the original Db - but, as I was aware, the form didn't work. Then I found the problem; Calibri font was causing all the angst. I remove all traces of Calibri replacing with Arial and everything worked beautifully. Can't see how that is possible, but the form has been working for over a week now.
I am guessing that removing Calibri from the computer and installing a new version will result in that font working on the form. If anyone else has any feedback, let me know.
Avagr8day, regards, Peter
-
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands