Input Percent field displays the same as typed in.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gil Jungert - 19 Jul 2005 14:14 GMT

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

Reply to this Message

Tim Ferguson - 19 Jul 2005 18:20 GMT

> 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

Reply to this Message