Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Decimal Places Field Formatting (2002)

    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.
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Decimal Places Field Formatting (2002)

    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.

  3. #3
    4 Star Lounger
    Join Date
    Sep 2002
    Location
    Stafford, Staffordshire, England
    Posts
    585
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Decimal Places Field Formatting (2002)

    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. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    <font color=blue><font face="Script MT Bold"><big>Rob</big></font face=script></font color=blue>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •