I amy trying to produce a tag that includes VAT from a SQL query to db that collects the data without it. No problems untill I start to add the VAT. All data comes through, and I get the right formatting on the field/label.
But as soon as I try to get the data using VB and adding the calculation *"1.25" the issues start. I have tried both to get te data as VB and to use VB to calculate the correct answers from a Db connection. I have plaid arround with most any setting I can dram up and no matter what I do I have problems with locale.
My end results end up being either of two scenarios:
- Amounts less then 1000 (999.00) ends up skipping the the decimal marker and printing the amount times 100! and amount above 1000 (1,000.00) prints just fine
- Amounts less then 1000 (999.00) prints just fine and amounts above 1000 (1,000.00) ends up printing as just a fraction of the value (1/100 of value i think it is.
I am hoping that I am missing something very obvious. Any idea?
Please sign in to leave a comment.