Percentage

[stephendeloach via AccessMonster.com]

I have a form with a Tax field. The property is set to Percent with 2 decimal
places. When I type in 6.75 it is changed to 675.00% ? I need it to say 6.75%
can anyone help me with this? Thanks

 

[ruralguy via AccessMonster.com]

I suspect the control is bound to an Integer field. Change it to something
that can hold a decimal: single, double, currency.

 

[Lynn Trapp]

The fact is that 6.75 IS 675.00%. You need to divide it by 100... so type in
..0675

 

[stephendeloach via AccessMonster.com]

I have it set to Double, Percent, 2....

I suspect the control is bound to an Integer field. Change it to something
that can hold a decimal: single, double, currency.

 

[ruralguy via AccessMonster.com]

I believe Lynn has hit the nail on the head. Thanks Lynn.

 

[Lynn Trapp]

You are welcome

 

[stephendeloach via AccessMonster.com]

Yes you are very right. Now how would I go about making it to where I type in
6.75 and it automatically goes to 6.75% instead of 675%? I know you need to
divide it by 100 but how would I put that in my form? Thanks

You are welcome

I believe Lynn has hit the nail on the head. Thanks Lynn.

[quoted text clipped - 7 lines]