Field Format Property

[KKash]

Hello - I'm trying to make my field in my table, form, and report read out as
a percentage. For example in my form I want to be able to type in 87.49 and
it read out in the table and report as 87.49%. In the Table Field Properties
I'm using Field Size - Single, Format - Percentage, and Decimal Places 2 but
I keep getting 8078.00%. In the Form and Report I have been able to get it
to read 80.78 but no percentage sign. Can anyone help???? Thanks!

kkash

 

[KKash]

Also this is in Access 2003. Thanks!

 

[KARL DEWEY]

A percentage is 1 (one) divided by a number like 1/5 = .2 or 20%.
You have to store the number in the table as 0.8749 as this is displayed as
87.49%.
Then you can format the text boxes in the form or report to display percent.

 

[KKash]

Thank You!

A percentage is 1 (one) divided by a number like 1/5 = .2 or 20%.
You have to store the number in the table as 0.8749 as this is displayed as
87.49%.
Then you can format the text boxes in the form or report to display percent.