View Single Post
  #3  
Old May 16th, 2007, 09:41 PM posted to microsoft.public.access.reports
Dennis
external usenet poster
 
Posts: 1,222
Default Using an ampersand in a report label control

THANK YOU!!! (I never thought that the old coding trick was also necessary in
a literal text field. *sigh*)

"John Spencer" wrote:

Simple one (if you know the secret)

Type TWO ampersands in a row and the caption will display One ampersand.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Dennis" wrote in message
...
In an Access 2002 report, I need to be able to have an ampersand (&) as
part
of the text in a couple of label controls. When I place the text into the
control for later display however, the ampersand disappears (being
replaced
by a tiny underline character), and does not show on the report. I need to
be
able to have something like:

"Alpha & Beta & Gamma"

for example. How do I get the ampersand character to display in the label
control?

thanks in advance!