TextBox Date format
Posted on 2004-03-30
Hello, I have formatted the value held in a textbox to type of currency.
Format (me.txtTotal.Text, "currency")
I have various textboxes on the form each with similar currency value in them. I want to be able to add up all the values in the textbox, e.g £23.50 + £5.34, the problem is that the results that gets returned is zero (0), because it (must then be) a string and not a numerical type datatype.
Is there a property that i can set that changes the default display of the textbox to a currency type but allows me to add up the values without having to pass then through a function to get values. This can be done in VB 6 and Access Forms, is there a setting on the textbox property that would help me do this?