Yes/No box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top