Word Check Box Field Value 1

[MysticMan]

I have created a form that includes calculations. I need to be able to test a check box field value (i.e. true or false, 0 or 1)to include in an If formula. For example, <br>
{If (check1 = true, {=text1*3}, {=text1*2})}<br>
The If statement works by checking the value of a text field or a dropdown field presumably because there is actual text to compare:<br>
({If (text1 = &quot;Yes&quot;, {=text1*3}, {=text1*2})})<br>
I'm not sure why I can't get the check box field value to work. Any thoughts?<br>
Thanks

 

[DougP]

I little known fact about VBA is<br>
True = Yes = -1<br>
False = No = 0<br>
<br>
Try any of these to see it that will work.<br>
<br>
In Access and VB you refer to a Checkbox like so<br>
<br>
IF Check1.Value = -1 then<br>
' The check box is checked<br>
ElseIf Check1.Value = 0 then<br>
' Not checked<br>
End IF<br>
<br>
Not sure if Word is the same way.<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>