decimal symbol doubt...

[rocco]

Hello,
I'm working on an application that needs to be used in the US and in Italy.
US uses "." (dot) as decimal separator while Italy uses "," (comma).
Few control in a form while receive decimal values. Since data should be
shared between Us staff and Italy staff, I need to manage the issue regarding
the decimal symbol.
My question is:
Is it possible that whatever regional setting do you have, Access will store
the decimal symbol as "." (dot)?
This will make things a lot easier because the difference between Italy and
US will be just a matter of format for visualizing data but there will be no
differences in how the data are stored.
Otherwise... I will lot of work to do, I guess...
Thanks
Rocco

 

[Rick Brandt]

Hello,
I'm working on an application that needs to be used in the US and in
Italy. US uses "." (dot) as decimal separator while Italy uses ","
(comma).
Few control in a form while receive decimal values. Since data should
be shared between Us staff and Italy staff, I need to manage the
issue regarding the decimal symbol.
My question is:
Is it possible that whatever regional setting do you have, Access
will store the decimal symbol as "." (dot)?
This will make things a lot easier because the difference between
Italy and US will be just a matter of format for visualizing data but
there will be no differences in how the data are stored.
Otherwise... I will lot of work to do, I guess...
Thanks
Rocco

Formatting is always about display and never has any effect on storage.

 

[rocco]

Thanks Rick,
i knew it.
Maybe I wasn't clear, I'm italian (!). I was wondering if whatever the
regional settings are, always a "." (dot) is used to store decimals into the
database. Something like what happen with dates that will be always stored in
a way to represent US format (although they are *really* stored as number).
And in fact whatever region you are you should always refer to dates in SQL
using US date format.
I hope to have made it clearer...
Thanks!
Rocco

 

[Rick Brandt]

Thanks Rick,
i knew it.
Maybe I wasn't clear, I'm italian (!). I was wondering if whatever the
regional settings are, always a "." (dot) is used to store decimals
into the database. Something like what happen with dates that will be
always stored in a way to represent US format (although they are
*really* stored as number). And in fact whatever region you are you
should always refer to dates in SQL using US date format.
I hope to have made it clearer...

The issue you describe about dates only applies when you are using date
literals in a SQL string or a saved query. I can't recall ever having
needed to use a decimal place literal so I can't say for sure. I would
suggest testing by changing your regional settings to see what the effect
is.

If you are talking about entries in bound forms then I believe the regional
settings would rule, but again I have never encountered this so I would have
to test it to be sure.

 

[rocco]

Thanks again Rick,
I' not a huge fun of bound forms. i prefer working with unbound form and
manage myself through code the saving of the data into the database.
I will go with your suggestion: changing the regional settings and see what
happens.
Thank you so much,
Rocco