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.
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.


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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

717 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