Fix the Wrong Percentage Format in a Microsoft Access Report
Question details
The user needs an Access report to display a percentage consistently with the underlying table value.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A report displays a percentage from an Access table.
- Observed behavior
- The table may show 93.03%, while the report shows 9303% because the report control's format or value interpretation differs.
Open the report in Design View and identify the text box displaying the percentage. Check its Control Source and compare the underlying numeric value with the value shown in the table.
Correct the Report Control's Percentage Format
Use this method when the source stores the percentage as a decimal, such as 0.9303 for 93.03%.
Percentage formatting multiplies the underlying number by 100 for display. A value of 0.9303 displays as 93.03%, but a value of 93.03 displays as 9303%.
Open the report in Design View, select the percentage text box, and open the Property Sheet. On the Data tab, check the Control Source for the field or expression supplying the value.
Open the source table or query and inspect the numeric value without percentage formatting. Confirm that the value is 0.9303 if it should display as 93.03%.
Return to the selected report text box. On the Property Sheet's Format tab, set Format to Percent and Decimal Places to 2.
Save the report and open Report View or Print Preview to confirm that the value displays as 93.03%.

Convert Whole-Number Percentage Values in the Report
Use a calculated control when the source stores 93.03 to mean 93.03% and you do not want to change the stored data.
Work With Exported Access Data in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface for working with exported data. Open compatible spreadsheet files and format percentages in WPS Spreadsheets; it does not repair Microsoft Access reports.

Frequently Asked Questions
Why does 93.03 appear as 9303% in my Access report?
The report's Percent format multiplies the underlying value by 100 for display. If the source value is 93.03, it displays as 9303%; the decimal value 0.9303 displays as 93.03%.
Where can I change the percentage format in an Access report?
Open the report in Design View, select the text box, and open the Property Sheet. On the Format tab, set Format to Percent and Decimal Places to 2.
Can I fix the report without changing the stored table values?
Yes. If the source stores 93.03 to mean 93.03%, set the report text box's Control Source to an expression such as =[FieldName]/100, then apply Percent format.
Why do the table and report display different percentages?
The table field and report text box can use different formats, and the report control can use a calculated expression. Check the text box's Format and Control Source properties in Design View.




