Datasheet view modifications lost on exit from Form

[davidjsimpson@btinternet.com]

I have been modifying an Access application I developed 2 years ago in Access 97. I have a multi page form running off a query. When I change the view to Datasheet and move and hide columns in the datasheet, the changes are lost when I next open the form, or when I go into Form Design and back to Form or Datasheet view. I have tried removing all my code and macros, without any effect. I have also created a new form from the same query, which allows me to change the Datasheet layout and save the changes without any problems. Any ideas what might be causing the problem? (I don't particularly want to recreate the entire form from scaratch as it is quite complex)

 

[Jack Cowley]

If the new form works and the old one doesn't then it sounds like the old one is corrupt. You can try importing it into a new database and see if that helps, but if not you will probably have to bite the bullet and rebuild your form....

 

[davidjsimpson@btinternet.com]

Thanks Jack. I'll try importing the form. Seems a pretty "neat" form of corruption - I asume there's a bit somewhere in the form or datasheet that either allows changes to datasheet layout / format or tells Access to save the change. Apart from this one problem everything in the form works perfectly. Does anyone know of a fix utility out there that might allow me to peek/poke the form?