[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