Field Reference

  • Thread starter Thread starter Donald Dudar
  • Start date Start date
D

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
 
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.
Click to expand...

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
:-)
 
Back
Top