Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Posts
    3

    Unanswered: Simple form text box problem

    All the text boxes in my recently designed MS Access 2000 form are rounding off the values I am entering. For example, an entry of 11.9 is rounded off to 12 even though I have the general properties in the corresponing table field set to Field Size - Decimal, Format - Fixed, and Decimal Places - 1. What am I missing?

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    what is the dat format of the number field in the underlying table?

  3. #3
    Join Date
    Sep 2001
    Posts
    175

    Re: Simple form text box problem

    Originally posted by O'Brolichain
    All the text boxes in my recently designed MS Access 2000 form are rounding off the values I am entering. For example, an entry of 11.9 is rounded off to 12 even though I have the general properties in the corresponing table field set to Field Size - Decimal, Format - Fixed, and Decimal Places - 1. What am I missing?
    You can try this:


    field set to Field Size - Double, Format - General Number, and Decimal Places - 1

    Hope that helps

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    that's where I was heading - good solution

  5. #5
    Join Date
    May 2003
    Posts
    3

    Talking Re: Simple form text box problem

    Originally posted by toukey1
    You can try this:


    field set to Field Size - Double, Format - General Number, and Decimal Places - 1

    Hope that helps

    Thank You! Those changes solved my problem. I really appreciate the response, and I learned something.

Posting Permissions

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