CheckBox Problem In Access97

Posted on 1998-10-15
Last Modified: 2006-11-17
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 ?        
Question by:davidpo
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4

Expert Comment

ID: 1965445
If your sure the code is correct, I would write the names down of each check box, delete them and replace with new boxes, making sure the correct names are attached.  this should solve your problem.


Author Comment

ID: 1965446
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.

Expert Comment

ID: 1965447
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.
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.


Author Comment

ID: 1965448
As mentioned, we tried this trick first.

Accepted Solution

kulikuli earned 200 total points
ID: 1965449
Sorry for misunderstanding. I suggest you write a function that:
opens each form in the form's documents collection of the database
loops through all the controls
if the control Is TypeOf check then store it's name, controlsource, left and top property in variables
delete the checkbox control
create a new checkbox control using the createcontrol method
put the stored properties' values in that control
save and close the form using the docmd object

It will cost very few lines to code and you don't have to worry about anything when it is finished.

Expert Comment

ID: 1965450
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.

Author Comment

ID: 1965451
We would like to try  kulikulis answer.
Can you add sample code ?

Author Comment

ID: 1965452
The problem is a BUG in Access 97 which causes this phenomenon when the "Navigation Buttons" property is "No".

Expert Comment

ID: 1965453
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,

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question