Non-Editable Form Fields

Question

In a protected form (Word table), Cell 1 is a number form field, Cell 2 is a number form field, and Cell 3 is a percentage calculation using the info in Cell 1 and Cell 2 ((Cell 1 / Cell 2) * 100). Cell 3 is therefore not user editable.

In protected status, my Cell 3 does not auto update once the information in Cell 1 and Cell 2 is provided.

Is it possible to get this form to react in this manner, and if yes, what would it take to do this.

I am using the Legacy Tools form fields.

Answer 1

You need to check the 'calculate on exit' property for the formfields in cells 1 & 2. In cell 3, you don't need a formfield. You can use a formula field instead, coded as:

{IF{=Cell2} > 0 {=Cell1/Cell2*100 # "0.00%"}}

Note1: Instead of the Cell2 and Cell2 references, you can use actual cell references, like A1 & A2. Also, the above field construction avoids divide-by-zero errors.

Note2: The field brace pairs (ie '{ }') for the above example are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.

Answer 2

Unprotect the document.

Double-click the form field in Cell 1.

In the Text Form Field Options dialog, tick the check box "Calculate on exit", then click OK.

Do the same for the form field in Cell 2.

Protect the document for forms again.