Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Numbers round.. I don't want that (97 sr2)

    I have a control on a form to enter the weight of an item. I set the field properties to long integer, fixed, 2 decimal places in both the underlying table and on the form. But, if I enter 5.66, it rounds to 6.00. Ahhhh! I can't find any reason for this. Where else can I look?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Numbers round.. I don't want that (97 sr2)

    Integers are whole numbers. Change the field to single.
    Regards
    John



  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbers round.. I don't want that (97 sr2)

    duh.... thanks! Sometimes it is so easy it's scary

Posting Permissions

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