Field Reference

[Donald Dudar]

I am designing a form, and have created a value
called "Sanctioned", which has a check box.

Later in the form is a table, which calculates the cost
of a programme, and considers, in part whether the
programme is sanctioned.

I am trying to create a calculated field in the table
that refers to the check box. I found an "if"
calculation, however, I cannot get the syntax right.
Currently, I am trying {if check1 = "true" 1 0}

The value that is returning has always been 0, so I
suspect the problem is the "condition" or "expression"
that should follow the operator.

Can anyone suggest a way to resolve this?

Thanks

Don

 

[Cindy M -WordMVP-]

Hi Donald,

In my experience, form field checkboxes return no value in
the document interface that you can check using another
field. They essentially "aren't visible".

The only way around this using a checkbox would be a macro
that would get the actual value and perform a calculation.
Or, the user would need to type something (basically,
anything) in a text formfield (1 character long), you could
then whether that = "" (empty string) or not.

Something else you can't do is use an IF (conditional) in a
form field calculation. This isn't a problem, however, as
having "Calculate on Exit" activated will also update
normal Word fields in the document. So you could use a
regular IF field, picking up the text form field value in a
REF field. It would look something like this, with field
codes on:
{ IF { Ref Text1 } = "" "True value" "False value" }
and this would probably need to be nested in a formula
field.

I am designing a form, and have created a value
called "Sanctioned", which has a check box.

Later in the form is a table, which calculates the cost
of a programme, and considers, in part whether the
programme is sanctioned.

I am trying to create a calculated field in the table
that refers to the check box. I found an "if"
calculation, however, I cannot get the syntax right.
Currently, I am trying {if check1 = "true" 1 0}

The value that is returning has always been 0, so I
suspect the problem is the "condition" or "expression"
that should follow the operator.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail