[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
>
>
>
>
>
>
>
>
> -----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
>


-- 
Gary Kjos
garykjos at gmail.com