Results 1 to 10 of 10
  1. #1
    blueraincoat is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Shanghai,CHN
    Posts
    99

    Number Filed in Form auto round

    Hi all,
    I have a form based on a table. There's a field in the table which is set to number, I have a text box in the form for entering this data.
    But when I enter 1.3, it automatically round to 1 when I changed the focus to another field.


    Can anyone figure out what I'm doing wrong?

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    check out properties. change the dec. places to 2, NOT auto. is the field bound to a table field? what are the props of that field?

  3. #3
    blueraincoat is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Shanghai,CHN
    Posts
    99
    I tried that but it's still the same.
    The field size was set to Long, would that be the problem?
    I also tried to enter the data in the table directly, it's the same.

  4. #4
    blueraincoat is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Shanghai,CHN
    Posts
    99
    I found what's wrong.
    The format property should be set to standard.
    Thanks for the tip.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Long is Integer only. In order to hold a decimal value you would need to use one of the DataTypes that can hold a decimal value: Single, Double, Currency.

  6. #6
    blueraincoat is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Shanghai,CHN
    Posts
    99
    You are correct Rural...
    It's a shame to make a mistake on this issue...

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    There is so much more to learn from our mistakes than our successes.

  8. #8
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by RuralGuy View Post
    There is so much more to learn from our mistakes than our successes.
    Not if your name's Obama...?? Right?? OK OK, just kidding you politicos!

  9. #9
    blueraincoat is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2011
    Location
    Shanghai,CHN
    Posts
    99

    That's true.

  10. #10
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I 2nd that!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 10-10-2010, 05:30 AM
  2. format number filed to significant digits
    By stileguru in forum Reports
    Replies: 3
    Last Post: 08-13-2010, 01:26 PM
  3. Auto-number
    By rkski in forum Programming
    Replies: 2
    Last Post: 01-13-2010, 02:04 AM
  4. Upercase in filed of form
    By miziri in forum Forms
    Replies: 2
    Last Post: 12-23-2009, 05:13 PM
  5. Need help with an auto number
    By Wrangler in forum Database Design
    Replies: 1
    Last Post: 02-10-2006, 03:21 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums