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!