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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comma as a decimal symbol (Regional and Language settings) 1
Comma as a decimal symbol (Regional and Language settings) 0
UDF returns #VALUE! when regional language setting not English!? 2
How to make table of contents for different regional settings? 3
How to change language for a administrator system message 2
Export to CSV via macro does not use local regional settings 2
How do I read user's regional settings ? 3
Changing the language of my system 1

Back
Top