Print "&" Symbol in Report

[Winks]

How do I print the "&" symbol in an Access 2007 report? The help
system says I should use the ASCI character 38 while holding the Alt
key. This works---I can see it in the caption property, but the label
won't show it.

I've also tried to copy/paste the symbol from the Windows character
map. I get the same results.

[Rich P]

Interesting. I never noticed that before. It is the same on Access
2003 (what I have on my workstation right now). The only way I have
found (in my 5 minutes of research on this) to get around this was to
create a bmp file in msPaint that said "test & test", and then place
that picture of "test & test" in an image control. Maybe there is
something easier. But this is what I came up with so far.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Wayne Gillespie]

On Mon, 25 Aug 2008 09:34:00 -0700 (PDT), Winks <se********@comcast.netwrote:

>How do I print the "&" symbol in an Access 2007 report? The help
system says I should use the ASCI character 38 while holding the Alt
key. This works---I can see it in the caption property, but the label
won't show it.

I've also tried to copy/paste the symbol from the Windows character
map. I get the same results.

Try doubleing the character -
eg Town && Country
Wayne Gillespie
Gosford NSW Australia

[Salad]

Winks wrote:

How do I print the "&" symbol in an Access 2007 report? The help
system says I should use the ASCI character 38 while holding the Alt
key. This works---I can see it in the caption property, but the label
won't show it.

I've also tried to copy/paste the symbol from the Windows character
map. I get the same results.

If a label I usually do a && in previous versions. Ex: You && I.

[Winks]

Excellent! The double && worked like a charm. Thanks for the help.