Form Automation

[khmoffat]

I am tring to create a form that will check or uncheck a box next to a
signature line to indicate if the signature is required or not.

I have several fields that are calculated.

The best I can do is using another field with a formula in it like
"=OR(OR(euro_total>0,swan_total>0),genus_total>0)"

this results in a 1 or a zero. I would rather have this as a checked or
unchecked box. Any ideas?

Right now I am assuming I need to use VBA for this hence my previous post.

 

[Graham Mayor]

Actually you don't need VBA for this. You can manage it with a conditional
field

{ IF{ =OR(OR({ euro_total } > 0, { swan_total } > 0),{ genus_total }> 0) } =
1 "A" "B"}

Watch the spacing - and insert field boundaries with CTRL+F9.

In place of A & B insert a checked box character and an unchecked box
character (wingdings 2 font) or vice versa depending on when you want the
box checked. Check the calculate on exit property for each of the three
checked fields.

See also "Testing for a value in one of several fields" at
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>