Calculate Currency values to total

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

Guest

Hi all,

I would like a text box to automatically calculate the total between two
values. In my table the values are set to currency, but the values do not
change in my form, however, when i generate a report, the values in the two
text boxes can change depending on other text boxes (the control functions to
which i have already done).
Example... If txtBoxA = 175.00 and txtBoxB = 175.00, txtTotal = 350.00. I
tried some code, but it just gave me "175.00175.00" it didnt give me a total?

Any Ideas?...Thanks in advance!
 
You are using a calcuation expression or formatting that is most likely
converting your numeric values to strings. Try:
=Val(txtBoxA) + Val(txtBoxB)
 
Back
Top