Simple Question (I hope) (Microsoft Access Forms)

Simple Question (I hope)
message from RC- on 1 Jun 2004
I have a report header that needs (doesn't really need it, but I would like to have it) an ampersand in the name. I.E. Company Listing & Directory. When I add it, it turns the "&" into an underscore "_" and the "&" doesn't show up even when the report is ran. Is there anyway around this? TIA RC-

Rick Brandt replied to RC- on 1 Jun 2004

Use 2 ampersands in a row.

RC- replied to Rick Brandt on 1 Jun 2004

Gheez!

Thanks!

"Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
news:2i3tf3Fid2f4U1@uni-berlin.de...

hcj replied to RC- on 1 Jun 2004

the reason this works (and is required) is because the
ampersand symbol has special function in Access. In order
to get the symbol itself to appear in text is to type it
twice in the string.
hcj
need it, but I would
Listing & Directory.
underscore "_" and the "&"

RC- replied to hcj on 1 Jun 2004

Yeah, I know is used to concatenate two strings together. I had a feeling
it would be a simple fix. Thanks for the extra info though!

RC-

"hcj" <anonymous@discussions.microsoft.com> wrote in message
news:1689701c44803$117fb3a0$a401280a@phx.gbl...

Wayne Cusack replied to RC- on 1 Jun 2004

You can use Visual Basic to put the text into the report,
using the ASCII character for the ampersand

it, but I would like
Listing & Directory.
and the "&" doesn't
around this?

hcj replied to RC- on 1 Jun 2004

I think the fix is to type the ampersand symbol twice in
your header string "Company Listing && Directory"
HTH
it, but I would like
Listing & Directory.
and the "&" doesn't
around this?

=?Utf-8?B?SmFja2llIEw=?= replied to RC- on 1 Jun 2004

You need to use two "&" in a row in order to show only one.

Archived message: Simple Question (I hope) (MS Access Forms)