decimal symbol doubt...

  • Thread starter Thread starter rocco
  • Start date Start date
R

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
 
rocco said:
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
Click to expand...

Formatting is always about display and never has any effect on storage.
 
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
 
rocco said:
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...
Click to expand...

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.
 
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
 
Back
Top