MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Percent formatting??

• Follow

```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

```
 0

```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

```
 0

```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
>

```
 0

```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
>

```
 0

```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
>>
>
>

```
 0

```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

"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
>>>
>>
>>
>
>

```
 0

5 Replies
300 Views

Similiar Articles:

8/1/2012 11:25:34 AM