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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

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

  1. #1
    Peter Farthofer Guest

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


    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

  2. #2
    Rohit Wason Guest

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


    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



  3. #3
    Peter Farthofer Guest

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


    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

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center