When I add the value of two txt fields (I should say numerical fields), I'm getting a wierd concatenation of the two varibles. I just want it to simply add the two values together! Here's what I found in the MSDN Database:
NOW...I'll be more specific about my problem:Quote:
+ Operator Example
This example uses the + operator to sum numbers. The + operator can also be used to concatenate strings. However, to eliminate ambiguity, you should use the & operator instead. If the components of an expression created with the + operator include both strings and numerics, the arithmetic result is assigned. If the components are exclusively strings, the strings are concatenated.
Code:Dim MyNumber, Var1, Var2
MyNumber = 2 + 2 ' Returns 4.
MyNumber = 4257.04 + 98112 ' Returns 102369.04.
Var1 = "34": Var2 = 6 ' Initialize mixed variables.
MyNumber = Var1 + Var2 ' Returns 40.
Var1 = "34": Var2 = "6" ' Initialize variables with strings.
MyNumber = Var1 + Var2 ' Returns "346" (string concatenation).
Here's the code
If txtPDA9.Value is = $2,000 and txtPDAO1.Value is = $3,432Code:txtTotal.Value = (txtPDA9.Value + txtPDAO1.Value)
txtTotal.Value = Format(txtTotal, "$#,##0")
'Format for first variable is = Format(txtPDA9, "$#,##0")
'"$#,##0" is the same format for txtPDAO1.Value
I am getting a return value of $2,003,432
In addition, I have tried several approaches and tactics to correct this with no luck...Can I disable the concatenation? I know that I can enable it with the & operator. Is this problem arising from the way that the fields are initialized? Please help.
Cordially,
Flint Puckett, MBA
J&J
