Why is it when I type 10 into a text box formatted as 'Percent' it shows 
1000%, and when I type 0.1 it shows 0.0%?

How do I make the text box accept 10 means 10%?

Sandy 

Hello Sandy.

"Sandy" wrote:
> Why is it when I type 10 into a text box formatted as 'Percent'
> it shows 1000%, ...

That's by design: "per cent" means "per hundet", so 1000% = 1000/100.

> ...and when I type 0.1 it shows 0.0%?

Probably the number field in the table has fieldsize integer or long.
To accept decimal places (10% = 10/100 = 0.1), it should be single or
double.

> How do I make the text box accept 10 means 10%?

Enter 10% instead of 10, that will work.

-- 
Regards,
Wolfgang 

I changed the table field format to single and it now works fine and 
calculates as it should.

Thank you Wolfgang
Sandy

"Wolfgang Kais" <w.kais@removethisgmxthistoo.de> wrote in message 
news:%23kSneBiKIHA.5116@TK2MSFTNGP03.phx.gbl...
> Hello Sandy.
>
> "Sandy" wrote:
>> Why is it when I type 10 into a text box formatted as 'Percent'
>> it shows 1000%, ...
>
> That's by design: "per cent" means "per hundet", so 1000% = 1000/100.
>
>> ...and when I type 0.1 it shows 0.0%?
>
> Probably the number field in the table has fieldsize integer or long.
> To accept decimal places (10% = 10/100 = 0.1), it should be single or
> double.
>
>> How do I make the text box accept 10 means 10%?
>
> Enter 10% instead of 10, that will work.
>
> -- 
> Regards,
> Wolfgang
> 

Does it work right if you type it directly in the table?
"Sandy" <sandy_stephenDELETE@hotmail.com> wrote in message 
news:eGa7O3hKIHA.1212@TK2MSFTNGP05.phx.gbl...
> Why is it when I type 10 into a text box formatted as 'Percent' it shows 
> 1000%, and when I type 0.1 it shows 0.0%?
>
> How do I make the text box accept 10 means 10%?
>
> Sandy
> 

No I have to type 10% in both table and form. If I type just 10 for example 
it shows 1000%.
Bit of a pain really.

Sandy

"Pete D." <pduffy211@cox.net> wrote in message 
news:if20j.2700$hV2.629@newsfe19.lga...
> Does it work right if you type it directly in the table?
> "Sandy" <sandy_stephenDELETE@hotmail.com> wrote in message 
> news:eGa7O3hKIHA.1212@TK2MSFTNGP05.phx.gbl...
>> Why is it when I type 10 into a text box formatted as 'Percent' it shows 
>> 1000%, and when I type 0.1 it shows 0.0%?
>>
>> How do I make the text box accept 10 means 10%?
>>
>> Sandy
>>
>
> 

Unfortunately, it's working as designed.

10% really means .1. Easiest approach would be to enter .1. Alternatively, 
you could use an unbound text box, divide the value by 100 in its 
AfterUpdate event and transfer it to a (hidden) text box bound to the field 
in the recordsource.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Sandy" <sandy_stephenDELETE@hotmail.com> wrote in message 
news:u0EMhYrKIHA.4808@TK2MSFTNGP05.phx.gbl...
> No I have to type 10% in both table and form. If I type just 10 for 
> example it shows 1000%.
> Bit of a pain really.
>
> Sandy
>
> "Pete D." <pduffy211@cox.net> wrote in message 
> news:if20j.2700$hV2.629@newsfe19.lga...
>> Does it work right if you type it directly in the table?
>> "Sandy" <sandy_stephenDELETE@hotmail.com> wrote in message 
>> news:eGa7O3hKIHA.1212@TK2MSFTNGP05.phx.gbl...
>>> Why is it when I type 10 into a text box formatted as 'Percent' it shows 
>>> 1000%, and when I type 0.1 it shows 0.0%?
>>>
>>> How do I make the text box accept 10 means 10%?
>>>
>>> Sandy
>>>
>>
>>
>
>