Weird percentage behaviour !?!

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a column defined as a number - integer, format
percent with no decimnal places. I can't figure out how to
update this column in a subform. It defaults to 0%. When I
change this to 5% and go to another row, it reverts to 0%.
If I delete what is there and just type 5, it comes back
500%. I'm at a total loss!!!

Is there a better way to get a user to type in a number
from 0 to 100?
 
When you set the format to percent, you made it so that people are entering
a percentage. Therefore typing in 5 is 5% which is 0.05. Since the data
type is integer 0.05 become 0. If you want a number between 0 and 100 I
would just use an integer without any format and just use validation to
limit between 0 and 100.

Kelvin
 
Back
Top