Number format regional settings in VB6
Posted on 2008-10-01
I have an app that is developed in vb6. When I do calculations I format numbers based on a '.' for the decimals. I now have customers in the Netherlands who format using ',' and when I do any calculations or submit the data I get errors.
How can I change this code for example:
myTotal = format(mysubtotal + mytax,"0.00")
rs!total = format(myTotal, "0.00')
I don't want to use the comma but would rather like code to do the math using the local regional settings.
Not all values are currency other some are qty's .
Please can anyone help