A number field that can contain 0 or 1 called AnswerOneNumber
A container field that contains a global graphic (check mark) or is empty
An invisible button that runs a script that would increment 0 to 1 or 1 to 0
Clicking on the invisible button over the container field AnswerOne
would increment AnswerOneNumber to 1 (checkmark appears) or to 0 (field is empty)
I have a contact database that contains five checkboxes that are calculated from five number fields
0 is white, 1 is green, 2 is yellow, 3 is red.
Five boxes, four options
Find scripts that will find white,green,green,green, red records for instance
Thanks for your help David. I'll keep those options in mind. I think I may have found a solution. Its probably more important in the report I want to produce so I have created a series of boxes with white ticks in them that use conditional formating to make the tick black when the field has the corresponding value. Its probably still a little clumsy but I think it is going to serve my purpose.