Formatting Issues

Fix the Wrong Percentage Format in a Microsoft Access Report

Ayan MasoodAyan Masood Nov 14, 2026 869 views

Question details

The user needs an Access report to display a percentage consistently with the underlying table value.

Fix the Wrong Percentage Format in a Microsoft Access Report
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.
Before you start

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.

Solution 1Recommended

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%.

1
Inspect the report control

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.

2
Check the source 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%.

3
Set the display format

Return to the selected report text box. On the Property Sheet's Format tab, set Format to Percent and Decimal Places to 2.

4
Preview the report

Save the report and open Report View or Print Preview to confirm that the value displays as 93.03%.

Correct the Report Control's Percentage Format
Check the scale first: Changing the Format property does not change the stored number. If the source value is 93.03 rather than 0.9303, adjust the value or the report expression before applying Percent format.
Free Microsoft Office alternative

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.

Format exported numeric data as percentages in WPS Spreadsheets.Open and edit Microsoft Excel XLSX files for easier migration.Use a familiar spreadsheet interface for everyday data tasks.Work with a free, lightweight Office alternative.
microsoft office alternative - wps office

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.