Formula field syntax for testing check box

[Dave]

I want to test the state of a checkbox to determine total price. i.e., if
check box = true then "50". I cannot find any info on how to properly place
that in a formula field. I thought it would be something like ${if { REF
check_box } = true "50" "0" } but nothing seems to work. Any suggestions for
me?

 

[Cindy M.]

Hi =?Utf-8?B?RGF2ZQ==?=,

I want to test the state of a checkbox to determine total price. i.e., if
check box = true then "50". I cannot find any info on how to properly place
that in a formula field. I thought it would be something like ${if { REF
check_box } = true "50" "0" } but nothing seems to work

It is not possible to test the state of a checkbox form field (or Activex
control) using another field. It can only be done with a macro.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

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