Form Automation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

khmoffat - 16 Jan 2006 22:38 GMT

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.

Reply to this Message

Graham Mayor - 17 Jan 2006 13:00 GMT

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

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> 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.
[quoted text clipped - 9 lines]
> Right now I am assuming I need to use VBA for this hence my previous
> post.

Reply to this Message

Rate this thread: