Field Format Property

  • Thread starter Thread starter KKash
  • Start date Start date
K

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
 
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.
 
Thank You!

KARL DEWEY said:
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.
Click to expand...
 
Back
Top