How do I use the & character in an Access Report Header?

  • Thread starter Thread starter Jeff B.
  • Start date Start date
J

Jeff B.

I am trying to create a report that uses the & character in the report
header, i.e., Salt & Pepper. When I enter that in the design phase, Access
2003 allows that, but when I execute the report, it substitutes an underscore
(_) for the & (ampersand). It is probably because the & is used as the
concatenation operator, but I haven't been able to find any way around this
yet. Do I use some kind of function or expression in the report header?
 
If you want the ampersand to appear then use TWO of them
Salt && Pepper



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top