I am trying to fix this bug. When I change language settins of my system from English (United states) to Dutch (Belgium), some values are displayed wrong in my software.
These values are read form access database. I am taking a value as a string and then displaying it using format function.
txtMax(i).Text = Format(Val(sProp), "#0.0#")
Each time I refresh my tab, value is changed. I think this is some rounding problem. Has anybody faced this before?
I understand that Belgian people use period (.) as thousand's separator and comma (,) as decimal point, which is exactly opposite to other locales' convention. And I have code format as '#0.0#'. Does this affect?
I want my application to run on both language settings. Can anybody help?
I am reading value from access database. 'sProp' is a string which contains value read from database. Now I am converting it to a number using Val function. Then a number is displayed in a text box.
All this looks fine when language setting is English (US), but when I select Dutch (Belgium), wrong values are displayed. When value is set to 40, text box displays 39.99, 38.96, 37.99,...; in the text box, each time screen is refreshed.
Is it some rounding error? How can I remove this?