Problems with Percent Format

  • Thread starter Thread starter Kajikawa
  • Start date Start date
K

Kajikawa

Guest
I have a basic form with a percent field that is giving us trouble. If I enter "95" it gives me "9500%" and if I enter ".95" it gives me "100%". If I enter "1" it gives me "100%" and anything below ".51" gives me 0%. :confused:
 
Hi, I am with the same doubt, and could not find the Article ID: Q142228 (I am new in the forum).
Where is this article?
 
I'm guessing your field is a Long Integer or Integer, set the format (at table level) to Double or Single.

And from here:Percentage format displays a percent value - that is, a number multiplied by 100 with a percent sign. Displays two digits to the right of the decimal place.
 
Thanks John! :)
Formating as double solve the problem.
 

Users who are viewing this thread

Back
Top Bottom