Fix Symbols Instead of Text in a Microsoft Access Report Field
Question details
An Access report displays symbols instead of an email address or other text, although the source table contains the correct value.

- Product
- Microsoft Access 2016
- Device & OS
- not provided
- Scenario
- Displaying a text field, such as an email address, in an Access report.
- Observed behavior
- The field label displays correctly, but the report value appears as symbol-like characters.
Open the source table and confirm that the affected record contains readable text. Identify the report and field name so you can compare them with the report control's properties.
Check the Report Field Binding and Formatting
Use this method when the source table is correct but one report field displays symbols.
Open the source table in Design View and check the affected field's Data Type. An email address is normally stored as Short Text.
Open the report in Design View, select the report, and open the Property Sheet. On the Data tab, check Record Source and confirm that its table or query includes the intended field.
Select the control displaying the symbols, not its label. In Property Sheet > Data, check that Control Source points to the correct field and is not an unintended expression.
With the control selected, open the Format tab in the Property Sheet. Try a standard text font such as Arial, check the font size, and clear any inappropriate Format setting. Confirm that the report uses a text box rather than an image or barcode control.
Save the report and open it in Report View or Print Preview. Check the affected record to see whether the email address now displays as text.

Recreate and Test the Report Text Box
Use a new control to test whether the existing report control is causing the display problem.
Review Exported Access Data in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility. Export Access data to an Excel workbook to review text in WPS Spreadsheets; WPS does not repair Access reports.

Frequently Asked Questions
Why does the label look correct while the email address shows symbols?
The label and value are separate controls. Open the report in Design View, select the value control, and check its Control Source, font, and Format properties in the Property Sheet.
Where can I check which field the report control uses?
In Design View, select the affected text box and open Property Sheet > Data. Check Control Source, then check the report's Record Source to confirm that the field is available.
What field type should an email address use in Access?
An email address is normally stored as Short Text. Open the source table in Design View to inspect the field's Data Type.
Can WPS Office fix the Access report?
No. The report's binding and formatting must be checked in Microsoft Access. You can export data from Access to an Excel workbook and review it in WPS Spreadsheets.




