Results 1 to 4 of 4

Thread: percent format

  1. #1
    Join Date
    Jun 2005
    Posts
    43

    Unanswered: percent format

    Hello:

    I was wondering if anyone knows whether a field formatted to percent truncates or rounds the percent?
    Mos

  2. #2
    Join Date
    Sep 2010
    Posts
    32
    I know mine don't but I have the field in the table set as Number (Single - Auto Decimal)

    And then I set the field in the form to Percent and it turns my decimals into the percentage .42551334 = 42.55%

    That works best for me but are you wanting it to round or ??

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    It should round the number.

  4. #4
    Join Date
    Jun 2005
    Posts
    43
    I think I found some pages indicating it just truncates, which is what I want. I just need "proof" of that. Found out there is also a round function in Access, and my code does not include that. Again, I want it to truncate, not round.

    I think I found my answers. Thank you.
    Mos

Posting Permissions

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