Yes/No box

S

SCP

Is there a way to add a currency value to a yes/no box. I have a box on a
form that I can tick if a customer has purchased this item - if it is ticked
i want it to add a monetry value formula in another box - can this be done
 
N

Nikos Yannacopoulos

A checkbox returns a numerical value of -1 when checked, and 0 if not.
So, to do what you want you would use an expression like:

= - [TxtItemPrice] * [chkPurchase]

where I have assumed that the checkbox is named chkPurchase, and the
textvbox with the price is named txtItemPrice.

HTH,
Nikos
 
Top