It you need to use the ampersand (&) in a label or text box in a Microsoft Access database, it will display as an underscore (_).

For example, you type and want to display “Sales & Marketing” but you get “Sales _ Marketing”.

To display the & symbol:

  • Double up the & – “Sales && Marketing”.  The result will be “Sales & Marketing

This is for you – Don, Chris, Marlana, Paul, Dan, & Noah!