Microsoft Access:  Use the Ampersand (&) in a Label

You may have wanted to use the ampersand in a text label before, but every time you type the ampersand in Design view, it doesn’t appear in Form or Report view. The reason is that the ampersand is a coding symbol used to concatenate text. In order for the ampersand to appear, you must type it twice.

Here’s how it looks in Design view: Apples && Oranges
Here’s how it looks in Form or Report view: Apples & Oranges

If you have any questions regarding this tip or need help implementing it in your own projects, contact Ranelle Maltas, Application Support Associate, at 472-0585 or e-mail at rmaltas2@unl.edu.