[AccessD] Regional Settings Problem

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Mon Mar 3 14:02:09 CST 2008


No.  I just got the email from him this morning.  I hardly know what to ask
him.  But I'm going to summarize the accumulated list wisdom and email back
with observations, questions, etc.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: segunda-feira, 3 de março de 2008 11:41
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Regional Settings Problem

Are your clients seeing the same thing in Brazil?  There are multiple levels
to regional settings, including the specifics of the decimal delimiter,
digit delimiter, etc.  Have you checked all those?

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 11:29 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Regional Settings Problem

You know everything works perfectly on my machine EXCEPT, when a field is
selected it displays American.  For example, a field contains 2.123.  When
regional settings (and keyboard) are set to  Portuguese (Brazil) is displays
1,123.  And when entering a number whether I press comma or period it
displays a comma.  

However, if I click or tab into a field so that the field is selected (shown
in reverse video) the comma becomes a decimal point. If I enter another
number in there like 4,567 it displays as 4,567 on entry, and, of course,
after I leave the field.  But if I go back to edit it and the whole field is
selected, it displays 4.567.

Any clues here:

TIA

Rocky





 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: segunda-feira, 3 de março de 2008 11:12
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Regional Settings Problem

No, the decimal format should work regardless of the regional settings.
But if the keyboard settings don't agree with the regional settings, that
could cause weird behavior.  

Charlotte Foust 

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

I'm guessing that if you have ANYTHING in that format parameter you are
going to have a problem as it will override the Regional Default setting.

It should be noted that I have never worked with any clients or users
outside the geographical confines of Minnesota though. ;-)

GK

On 3/3/08, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com>
wrote:
> 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
>
>

--
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: 2/3/2008
15:59
 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.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: 2/3/2008
15:59
 





More information about the AccessD mailing list