Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006

    Unanswered: percentage format problem

    Hi, I have set up a field in a form for a percentage. when I enter "70" i get a display of "7000.00%". when I enter ".45" for 45% it displays "0.00%".

    The question is this, can I format the field in the underlying table so a person can type "45" and display "45.00%" ?


  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    The key is in what you just said. You want a DISPLAY format, not a data storage format. Store your values as a decimal, do the math on them while they're getting stored, then display them as you wish.

    You're setting yourself up for all sorts of horrific arithimatical errors if you store a percentage as anything but the decimal value it represents.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Apr 2006
    Huddersfield, UK
    hio there;

    you can format it the percentageto achieve the following results:

    when .70 is inputted 70% is displayed
    when 1 is inputted 100% is displayed
    when 10 is inputted 1000% is displayed
    When .45 is inputted 45% is displayed and so on....

    set your field to numberr
    field size = decimal
    format = percent

    hope it helps

    sometimes simple is best.... and i'm just a simple fellow.

  4. #4
    Join Date
    Feb 2006
    thanks for your help!!!!!!!

Posting Permissions

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