How to make the Checkboxes write to records as 0 and 1 and not true false

Ok guys,

I need a few more small touches to complete my project.

My excel sheet has to be perfect for my parser to accept the data, so that is why these small things are so important.

My Worksheet has a correct incorrect column using 1 and 0 's
I need a 1 and 0 in each row.

When I submit a new record I can do the following and it shows my TRUE record as a 1 but all my FALSE 0 records as blanks.

The problem here is that my False rows are blank and not ZEROS
I use the - after the = and before the value

.Cells(iaRow, 2).Value = -Me.CBTrvAns1.Value
.Cells(iaRow + 1, 2).Value = -Me.CBTrvAns2.Value
.Cells(iaRow + 2, 2).Value = -Me.CBTrvAns3.Value
.Cells(iaRow + 3, 2).Value = -Me.CBTrvAns4.Value


Now when I do an update statement it looks like the following

CBTrvAns1.Value = r2Find.Offset(4, 2).Value
CBTrvAns2.Value = r2Find.Offset(5, 2).Value
CBTrvAns3.Value = r2Find.Offset(6, 2).Value
CBTrvAns4.Value = r2Find.Offset(7, 2).Value

I have tried to but the - and the *1 but I cant get it to return anything but TRUE and FALSE to my worksheet


Any help would be greatly appreciated.

below is my code

Please Login or Register  to view this content.

Norie,

Thanks that worked for that section what about on


CBTrvAns1.Value = r2Find.Offset(4, 2).Value