• Decimal Places Field Formatting (2002)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Decimal Places Field Formatting (2002)

    • This topic has 2 replies, 2 voices, and was last updated 18 years ago.
    Author
    Topic
    WSbandido
    AskWoody Lounger
    May 3, 2007 at 5:44 pm #442123

    I have an irritating little problem which I’m sure has an easy solution. I have a field in a table formatted as a general number set to 2 dp. However, when I enter 12.50 via the table or a form, the number displayed in the table or the form is “12”, that is, with no dp.
    What am I doing wrong?
    TIA.

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      May 3, 2007 at 5:57 pm #1063520

      What is the field size? If it is set to Integer or Long Integer, the field will store only whole numbers, regardless of what you enter. In order to store fractions, the field size must be Single or Double.

      Reply | Quote
      • WSbandido
        AskWoody Lounger
        May 3, 2007 at 6:03 pm #1063522

        Thanks Hans. It was set to Long Integer and I’ve now changed it to Double as you suggested but it still didn’t work until I changed the format to Fixed. All OK now. cheers

        Reply | Quote
    Viewing 0 reply threads
    Reply To: Decimal Places Field Formatting (2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.