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

  • Thread starter Thread starter Jeff J Jones
  • Start date Start date
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
 
Back
Top