Weird Button Caption Problem

[Jasper Jones]

For some reason if I set the text property of a command button to
something like "Mr & Mrs Smith" the end result is a command button with
the caption of "Mr _Mrs Smith". Does anybody know how I can include
the & sign in my command buttons? Is this a bug? Is there a work
around?

Please help, I really need the & symbol to work as I'm reading these
names from a database and it looks daft with the underscore...

 

[Herfried K. Wagner [MVP]]

For some reason if I set the text property of a command button to
something like "Mr & Mrs Smith" the end result is a command button with
the caption of "Mr _Mrs Smith". Does anybody know how I can include
the & sign in my command buttons? Is this a bug? Is there a work
around?

Replace each single "&" character by two consecutive "&" characters ("&&").

 

[Jasper Jones]

Thank you so much.