Changing system Language/Region setting affects the format of data returned to VB program.

J

Jeff J Jones

I have a VB application which utilizes an Access 2000 database.

It works fine when the user's Language/Regional setting is "English (US)".
But, change the Lang/Reg to "French (Canadian)" and a typical fraction that
would have returned as "3.14" is returned as "3,14".

Notice the comma instead of the period for the decimal separator. So If I
try to use this number in any SQL string - of course it bombs.

How do I solve this please?
 
?

___

In your control panel open "Regional Options" or "Regional Settings
depending on your Windows version and select the numbers tab. Chang
the Decimal Symbol to "." and apply.

HT
 
Top