Hi, all. I am an Access developer, but i'm pretty comfortable with Excel and Word... except this forms thing - never had to set them up before.
i'm talking about making a document a locked form, where you can only fill out the grey fields (similar to PDF forms).
I've figured out text fields and even formulas, but the formulas tend to add up any numbers, which are in the table cells, even if they are not part of the "grey" form fields (they're part of field descriptions).
also, the formulas don't "get" that a checkbox is either "0" (unchecked) or "-1" if checked, they ignore the checkboxes, even though i've custom-named each checkbox and included it in the formula.
ideas?
P.S. This is basically an assessment sheet, which has a table where there's a checkbox in each column and the last column needs to total them.
i'm talking about making a document a locked form, where you can only fill out the grey fields (similar to PDF forms).
I've figured out text fields and even formulas, but the formulas tend to add up any numbers, which are in the table cells, even if they are not part of the "grey" form fields (they're part of field descriptions).
also, the formulas don't "get" that a checkbox is either "0" (unchecked) or "-1" if checked, they ignore the checkboxes, even though i've custom-named each checkbox and included it in the formula.
ideas?
P.S. This is basically an assessment sheet, which has a table where there's a checkbox in each column and the last column needs to total them.