>I want to be able to cycle a checkbox through all for possible values (0, 1, 2, & NULL) by clicking on it. I can't seem to get this to work. Also, I need to store the value into a field and the disply the checkbox properly. I've tried some code in the click event to check the current value and set the value to the next option and yes, I did include a NODEFAULT. It didn't work. Any ideas on how to do these two things?

One thing close to this I have done is to use a image control instead of the checkbox control. When clicking on it we can change the image to represent what we need and also taking care of putting the correct value in the table.

I have done this for a checkbox because I don't like the way it works now. So, I have built one empty box and one checked box for that purpose which was changing from on to off when clicking on it.

That was our first attempt.

Then, for that specific need, I have found a better way which was consisting of using the text control instead and using the character which contains an empty box and the other one which contains a checkmark box.

Using a class for that was, of course, the way to go. :)