Input Percent field displays the same as typed in.

[Guest]

When setting a format to "Percent" in the table defination any amount input
is multiplied by 100 and a "%" symbol is added. e.g. If I enter 5.5 in the
field the field will display 550%. I would like to enter the amount in the
field as the actual percent amont 5.5% and have the field display 5.5%, while
at the same time the table will populate with the decimal equivelant of .055

 

[Tim Ferguson]

When setting a format to "Percent" in the table defination any amount
input is multiplied by 100 and a "%" symbol is added. e.g. If I enter
5.5 in the field the field will display 550%. I would like to enter
the amount in the field as the actual percent amont 5.5% and have the
field display 5.5%, while at the same time the table will populate
with the decimal equivelant of .055

Well, simple mathematics explains that five-and-a-half is 550%.

If you just want to display a percent symbol in the field, you can still
use a Format to do that: enter

0.0\%

into the Format property of the text box... Access removes the backslash
but appears to obey it, thus appending the character without affecting
the displayed numeric value. Try entering 0.0% instead and you will see
the value magnified.

This is tested in Access 2002... YMMV.

Best wishes


Tim F