Display a Literal Ampersand in a Microsoft Access Report
Question details
The user needs to display a literal ampersand within text in a Microsoft Access report label or unbound text box.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Adding report text such as Director, HR & Admin without binding the control to a database field.
- Observed behavior
- The ampersand is treated as a special character. The user reports an underscore and no ampersand when entering surrounding text without a field or an equals sign.
Open the report in Design View and select the control containing the text. Check whether it is a label or a text box: labels use the Caption property, while text boxes use Control Source.
Use a doubled ampersand in a report label caption
Use this method when the text belongs to a label control rather than a text box.
In the Navigation Pane, right-click the report and choose Design View. Select the label, then press F4 to open its Property Sheet.
On the Format tab of the Property Sheet, set Caption to Director, HR && Admin. The two consecutive ampersands represent one literal ampersand in the label.
Save the report and switch to Print Preview. Confirm that the label displays Director, HR & Admin.
Set an unbound text box to a quoted text expression
Use this method for the reported unbound text box, especially when the ampersand appears within a longer phrase.
Create Static Report Documents with WPS Office
WPS Office does not edit Access report controls or replace the Access database engine. For a static report document, it offers a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility, making migration of supported documents straightforward.

Frequently Asked Questions
Why does my Access label hide the ampersand?
Access can interpret a single ampersand in a label caption as an access-key marker. In Design View, select the label, press F4, and enter two ampersands in Caption, such as HR && Admin.
What should I enter for an ampersand surrounded by text in an unbound text box?
Select the text box and set Property Sheet > Data > Control Source to ="Director, HR & Admin". Include both the leading equals sign and the quotation marks.
Can I use Chr(38) instead of typing the ampersand?
Yes. In the text box's Control Source, use =Chr(38) for the ampersand alone, or ="Director, HR " & Chr(38) & " Admin" for a complete phrase.
Should I double the ampersand inside a text-box expression?
No. Use one ampersand inside quoted text, such as ="HR & Admin". The doubled-ampersand method applies to a label's Caption property, not to a quoted text-box expression.
Can WPS Office fix this formatting in an Access report?
No. Edit the report's Caption or Control Source property in Microsoft Access. WPS Writer can create a separate static report document, but it cannot edit Access .accdb report controls.




