Formatting Issues

Display a Literal Ampersand in a Microsoft Access Report

John WilsonJohn Wilson Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1

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.

1
Select the report label

In the Navigation Pane, right-click the report and choose Design View. Select the label, then press F4 to open its Property Sheet.

2
Edit the Caption property

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.

3
Check the displayed text

Save the report and switch to Print Preview. Confirm that the label displays Director, HR & Admin.

Use this syntax for labels: A single ampersand in a label caption can act as an access-key marker. Doubling it escapes that behavior; do not apply this rule to quoted text-box expressions.
Free Microsoft Office alternative

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.

Type literal ampersands directly in WPS Writer report text without Access label-caption escaping.Work with Microsoft Word .docx, Excel .xlsx, and PowerPoint .pptx formats.Use familiar document-formatting tools in a lightweight Office suite.Move supported Office documents into WPS without rebuilding them from scratch; Access .accdb reports still require Access.
microsoft office alternative - wps office

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.