[AccessD] Regional Settings Problem

Rocky,

What we had to do in our apps was to allow for the regional settings (it
could be worse, France uses a space as a delimiter) and have a function
that casts any number passed into it back into US format for use in SQL,
etc.  Similarly, we have a function that casts dates in US format for
SQL purposes.  All Our exports convert the data to US format and the
import converts that to the local regional settings if needed.  A lot of
initial work, but we have clients all over the world.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Monday, March 03, 2008 10:39 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Regional Settings Problem

The format for the field I tested is Fixed with decimal places set at 3.
There is no input mask.  Is that what's causing the problem?  Is there a
better format which would do what I need for the U.S. and not make a
conflict  with the foreign users?

Regards,

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Monday, March 03, 2008 9:32 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Regional Settings Problem

Do you perhaps have defined Formats for the field on the form that might
be overriding the User Setting?

GK

On 3/3/08, Rocky Smolin at Beach Access Software
<rockysmolin at bchacc.com>
wrote:
> Dear List:
>
> I have a dealer in Brazil who brought something to my attention.  In 
> Brazil they use the comma as a decimal point and a period to separate
thousands.
>
> When I set my regional settings to Portuguese(Brazil) I can enter 
> fractions like 2,123.  But the comma (their decimal point) appears 
> whether I press comma or period.  That's probably OK.
>
> After the field is updated it shows as 2,123 but if I select the field

> it displays as 2.123.  So I can enter fractional quantities using the 
> comma and it displays correctly after update.  The only time the 
> period shows is when an already entered number in a field is selected.
>
> But this is causing him some trouble.  What am I missing on this 
> Windows Regional Setting thing?
>
> MTIA
>
> Rocky
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


--
Gary Kjos
garykjos at gmail.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.21.3/1307 - Release Date:
3/2/2008
3:59 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com