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