Hi,
I'm Vince. I'm developing a small application in MS Access for a German client. In India we use "." for decimal places and "," for group separators. But in Germany it is different like they use "," for decimal places and "." for group separators. we have coded the application, without taking German practice into the consideration. Now the problem comes when the client started using the application and entering the decimal places. The application is saving the numbers " 0.66" as "66" and "1.66" as "166". That is it is not considering the "." as decimal. But the client now want to enter only "." as decimal but want to see "," in place of decimal i.e. he will enter "1.66" and want to see as "1,66" on the front end. While doing so, the regional settings need to be changed, for which client is not ready. Can you please tell me how can I solve this problem without changing his regional setings (numbers). If changing regional settings is the only solution, how can I do that using API calls? And at the closing of the application, his old regional settings should be back.