Percent formatting??

[Sandy]

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

 

[Sandy]

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

Thank you Wolfgang
Sandy

 

[Pete D.]

Does it work right if you type it directly in the table?

 

[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

 

[Douglas J. Steele]

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.