... format a cell to percent ...

[Guest]

I want to type 50 into a table and want it to register 50%.

When I format the entry as percent. I don't get the desired result.

Do I have to do something other that just format as percent?

Thanks,
Darrell

 

[Allen Browne]

You can type:
50%
or
.5
and Access will interpret it as 50%.

If you are using a form to enter the data, this article explains how to have
50 interpreted as 50%:
Enter a value as a percent
at:
http://allenbrowne.com/casu-16.html

You might also be interested to know that the next version of Access (2007)
will do this without the code.

 

[Guest]

50 / 100 (format as a percentage) = 50%

So

FieldName: ([PercentField]/50)

 

[Al Camp]

Dr.
Use the AfterUpdate event of the field...
YourNumber = YourNumber / 100