Corruption of text boxes in forms

[chris klein]

(1) I have a form "Ana," many copies of which I use to enter/edit data in numerous different data tables that are contained in several entirely different databases (i.e. different .mdb files).
(2) All of a sudden, in ALL versions of "Ana" and in ALL of my databases (i.e. load one .mdb, check it, close it, load another, check it, close it, etc) , the text boxes for three particular fields are showing garbage, and have lost the text box label which was on the form: field "name" (text field), field "date" (standard date format) and field "time" (standard time format).
(3) There does not appear to be any damage to the underlying data in these fields (i.e., no damage to the tables), only to the text boxes and associated labels on the forms.
(4) If I take any one of these "Ana" copies, open in design view, delete these three text boxes and drag in new versions from the View Field List, the result works fine.
(5) Compact and repair database does not fix the situation.
(6) DOES ANYONE HAVE A CLUE WHAT HAS HAPPENED? ARE MY DATABASES IN DANGER OF BEING CORRUPTED BY THIS? It would seem that Access itself has become corrupted, not the .mdb files, but this is wierd!

 

[quest4]

When I get strange Access behavior, which is not to often, I rename the old dbase and create a new blank dbase, then import everything into it, do a C&R and I am usually off and fling. Every now and then Access will go nutsy Cue-cue, I can not explain it, unless you did some modifications resently. hth.

 

[chris klein]

Found source of pbm: XP Hibernate

After posting the problem I was able to access another machine with Access installed, port my .mdbs there and test: sure enough, no problem found. Then re-booted my own machine and found problem has disappeared. Since I normally use Hibernate (windows XP Prof SP2), it appears that XP Hibernate was slowly corrupting memory or something at a location where Access was processing the text boxes. Lesson learned: Hibernate too much and you just get bad dreams.

 

[quest4]

Glad to see everything is working for you. This is the second time in a week that XP has been the culperate in a problem. The leason I am learning is not to use PC's with XP, ExPerimental, on them.