Nifty Check Box
The Microsoft Access interface has improved substantially over the years. However, for some reason one of the most basic components you can put on your MS Access Form, the humble check-box has remained the same standard 1990s style object. Well, that’s about to change! I’ve made my own “Nifty Check Box” which you can see demonstrated in the video below. It’s based on a command button. You can change the command button image, having one image for the true, and one for false, or if you prefer, the yes/no response you want from the simulated check box.
Nifty Check Box - Setup Videos
Nifty Check Box - Over View 1
Video 1 (4:32)
Run through of the “Nifty Check Box”
Explanation of how a normal Check Box works.
How a normal Checkbox links to the table.
I Demo the Boolean values used in a checkbox the -1 and 0.
You cannot link a Command Button to the underlying data.
I show how the option group frame is actually linked to the underlying data.
I mentioned that I’ve got a solution which you can see in the next video! – Nifty Check Box – Over View 2
Nifty Check Box - Over View 2
Video 2 (7:48)
I thought What’s the problem with the standard MS Access Check Box? And how can I solve it? The problem is, the Check Box needs to be bigger.
I realised it would also be nice if you could use your own images for the Check Boxes.
Well, I’ve come up with a method which allows you to use your own images! And here it is. I replaced the Microsoft Check Box with a Command Button, a Command Button with an image on it. When you click on the Button, it changes the image from an empty unchecked checkbox to a checked checkbox.Nifty Check Box - Setup 3
Video 3 (4:58)
I thought What’s the problem with the standard MS Access Check Box? And how can I solve it? The problem is, the Check Box needs to be bigger.
I realised it would also be nice if you could use your own images for the Check Boxes.
Well, I’ve come up with a method which allows you to use your own images! And here it is. I replaced the Microsoft Check Box with a Command Button, a Command Button with an image on it. When you click on the Button, it changes the image from an empty unchecked checkbox to a checked checkbox.Nifty Check Box - Adding Icons - 4
Video 4 (5:41)
I thought What’s the problem with the standard MS Access Check Box? And how can I solve it? The problem is, the Check Box needs to be bigger.
I realised it would also be nice if you could use your own images for the Check Boxes.
Well, I’ve come up with a method which allows you to use your own images! And here it is. I replaced the Microsoft Check Box with a Command Button, a Command Button with an image on it. When you click on the Button, it changes the image from an empty unchecked checkbox to a checked checkbox.… …