Reference Check Boxes in a Formula

Question

I am creating Word documents to use in an office setting so that my employees can fill out certain areas of the form which would then calculate costs and other job related numbers. I am looking to reference a check box in a formula, but am unsure if it is possible to do so. If it is, how does Word represent the status of the check box? I.e. 1/0, true/false, etc. Further, is it possible to then assign the check box a bookmark and reference the status of the check box in a conditional statement such as =NOT(x) or =AND(x)?

Thank you in advance!

Stern

Answer 1

I assume you're referring to checkbox formfields. You cannot cross-reference checkbox formfield results from another field. A macro is required for anything that is required to process them. Accordingly, you might get better results using a dropdown formfield to simulate the checkboxes, as you can reference dropdown formfield results from other fields. Using dropdown formfields also enables you determine whether a particular 'check' option has actually been chosen, rather than skipped over.

Answer 2

macropod, 

Thank you for your help. I guess I was thinking check box fields in Word worked similarly to when a check box is assigned to a cell in Excel and that cell displays T/F depending on the status of the check box. 

Thank you for your help.

Stern