Multiple ampersands (&) in label caption

[Jon Beets]

Folks,

To display an & in a caption on an Access form you quote it with another &,
ie. &&.

If however you have multiple ampersands in a caption, the second ampersand,
even though it is quoted, Access still appears to regard it as an Acess Key
and underlines the following letter. Subsequent ampersands if quoted appear
as two ampersands.

For example this string "Test of 1 && 2 && and 3 &&!" is displayed as "Test
of 1 & 2 &_and 3 &&!"

I have confirmed that in VB6 at least, "Test of 1 && 2 && and 3 &&!" is
displayed as "Test of 1 & 2 & and 3 &!"

Is this a known bug? It seems so simple to me, I am not sure if I am
missing something!

Jon

 

[Douglas J. Steele]

Yeah, I'd say it's a bug: it works properly in Access 97.

One approach people sometime take is to put a textbox rather than a label.
You can lock it so that it can't be changed.

 

[Jon Beets]

I will try the textbox idea. Thanks for the tip.

It works properly in Access 2000 too. I am using 2003!

Jon

 

[Douglas J Steele]

I've reported the problem to Microsoft. I'll post back here if I get a
response.