Problems with bound text controls to Access DB when comma (",") used as decimal charcter

[Peter Farthofer]

In Austria we use the comma as decimal character. Access is doing that nicely.
When I access numerical fields of an AccessDB the "," is displayed but when
you change the number it is no longer interpreted as decimal character and
so e.g. 25,83 becomes 2583! If I use "." as decimal Character this works,
but the users won't accept that.
Thanks in advance
Peter

[Rohit Wason]

Peter,

ADO works with elementary data types in the manner as you send for insertion/
updation.

1) Do you have the regional settings alligned to your requirements. By this,
I mean do you have the "Decimal Symbol" set as "," in the Regional-Setting
box of Control Panel?

2) If the above is done, use CInt/CLng (Whatever the case be), while Inserting/Updating
the data into Recordsets.

HTH
Cheers,
Rohit




"Peter Farthofer" <pfarthof@yahoo.com> wrote:
>
>In Austria we use the comma as decimal character. Access is doing that nicely.
>When I access numerical fields of an AccessDB the "," is displayed but when
>you change the number it is no longer interpreted as decimal character and
>so e.g. 25,83 becomes 2583! If I use "." as decimal Character this works,
>but the users won't accept that.
>Thanks in advance
>Peter

[Peter Farthofer]

Rohit,
thanks for your answer.
Concerning 1): Yes the regional settings are OK (that is probably the reason
that "," is used as decimal character when displaying numbers with fractions)
Concerning 2): As the text control is bound to the respective field in the
current record in a table in an Access DB the update is not done via code!
(And should not be with a bound control!!!)

Best regards
Peter


"Rohit Wason" <rohitw@ggn.hcltech.com> wrote:
>
>Peter,
>
>ADO works with elementary data types in the manner as you send for insertion/
>updation.
>
>1) Do you have the regional settings alligned to your requirements. By this,
>I mean do you have the "Decimal Symbol" set as "," in the Regional-Setting
>box of Control Panel?
>
>2) If the above is done, use CInt/CLng (Whatever the case be), while Inserting/Updating
>the data into Recordsets.
>
>HTH
>Cheers,
>Rohit
>
>
>
>
>"Peter Farthofer" <pfarthof@yahoo.com> wrote:
>>
>>In Austria we use the comma as decimal character. Access is doing that
nicely.
>>When I access numerical fields of an AccessDB the "," is displayed but
when
>>you change the number it is no longer interpreted as decimal character
and
>>so e.g. 25,83 becomes 2583! If I use "." as decimal Character this works,
>>but the users won't accept that.
>>Thanks in advance
>>Peter
>