davidpo
asked on
CheckBox Problem In Access97
After conversion of application written in Access 7 to
Access 97 the check-box does not function properly:
clicking on mouse doesn't do anything, but pressing <space> does check the box.
When we "Design" the form and then change to "Form View" it works OK, but when we "Open" directly to form view we encountered this problem
We tried to create a new database in Access97 and to import everything into this new database, but it doesn't solve the problem.
How can we fix this problem ?
Access 97 the check-box does not function properly:
clicking on mouse doesn't do anything, but pressing <space> does check the box.
When we "Design" the form and then change to "Form View" it works OK, but when we "Open" directly to form view we encountered this problem
We tried to create a new database in Access97 and to import everything into this new database, but it doesn't solve the problem.
How can we fix this problem ?
ASKER
Even a new check-box on the same form does not function properly.
Only on a new form the check-box works OK
Of course, it is not reasonable to recreate every form in the application.
Only on a new form the check-box works OK
Of course, it is not reasonable to recreate every form in the application.
I would strongly recommend an old (and very often and boring mentioned) trick: create a new database in MS Access97 and import all the objects from the converted database. This will cause MS Access to create all objects using the 97 standards.
ASKER
As mentioned, we tried this trick first.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If none of your checkboxes works ok (as you mentioned in another comment) then I would consider reinstalling MS Access in the first place. I converted forms from 95 to 97 without any problems considering checkboxes.
ASKER
We would like to try kulikulis answer.
Can you add sample code ?
Can you add sample code ?
ASKER
The problem is a BUG in Access 97 which causes this phenomenon when the "Navigation Buttons" property is "No".
DavidPo,
I am very happy you got it solved. I guess I just learned something new. Thanks for commenting your own solution. Also many thanks for grading me, although I didn't know about the bug.
I still can't logically explain any link between the navigation buttons and a checkbox, however. Does your solution mean that you HAVE TO have the navigation buttons displayed in order to avoid errors???
Best regards,
kulikuli
I am very happy you got it solved. I guess I just learned something new. Thanks for commenting your own solution. Also many thanks for grading me, although I didn't know about the bug.
I still can't logically explain any link between the navigation buttons and a checkbox, however. Does your solution mean that you HAVE TO have the navigation buttons displayed in order to avoid errors???
Best regards,
kulikuli
specialist