[AccessD] Regional Settings Problem

Charlotte Foust cfoust at infostatsystems.com
Mon Mar 3 15:07:31 CST 2008


Rocky,

There's a regional setting on the advanced tab that says "Apply all settings to the current user account and to the default user profile".  Could this be missed?  The Advanced settings are for non-unicode programs, which includes Access, doesn't it?

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




More information about the AccessD mailing list