Others

Fix Symbols Instead of Text in a Microsoft Access Report Field

Muhammad TalhaMuhammad Talha Nov 22, 2026 868 views

Question details

An Access report displays symbols instead of an email address or other text, although the source table contains the correct value.

Fix Symbols Instead of Text in a Microsoft Access Report Field
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.
Before you start

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.

Solution 1Recommended

Check the Report Field Binding and Formatting

Use this method when the source table is correct but one report field displays symbols.

1
Check the source field

Open the source table in Design View and check the affected field's Data Type. An email address is normally stored as Short Text.

2
Inspect the report source

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.

3
Check the control binding

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.

4
Review the appearance

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.

5
Preview the result

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.

Check the Report Field Binding and Formatting
Free Microsoft Office alternative

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.

Review exported email addresses and other text in a spreadsheet.Open and edit Microsoft Excel XLSX files and other Office formats.Use a familiar interface to make the transition from Microsoft Office easier.Work with a free, lightweight Office suite.
microsoft office alternative - wps office

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.