Insert -1 when box is check and NOTHING if not

[ARickert]

In my form I have several check boxes, however when it goes to the table it's converted to numbers (this makes it so that while clicking around the table you cannot accidently click a box and mess up the numbers). I want it to enter a 1 when the box is check, and NOT the 0's if nothing is checked. I want to be able to see at a glance where the -1's are, not lose them is a sea of 0's.



Thank you in advance for any help.

[ConneXionLost]

If you are storing your Yes/No data as numbers in your table, and expecting to view the table, then you could use this format style:

0;\-0;""

for the table fields.