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

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?
 
J

John Spencer MVP

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display of character "&" in titles, headers or labels 2
access 2002 report header 5
How do I add a report header to an existing report? 3
How can I repeat Report Header section on subreports? 1
Unusual Calculation in Report Header 3
'Freeze' Report Header and Page Header in screen view - possible? 3
How do you print an & it the middle of text 3
Bound Chart in Report Issues - Access 2007 4

Top