Ampersand in caption property conversion 1

[KeyserSoze]

I have some code in a form that takes data from an Access table and places it into the caption property of a label object on the form. This data has the ampersand (&) character in it. When the label object is painted onto the screen, the ampersand changes to a underline (_) for hot key operations.

Is there a way to deactivate this feature for a label object? I am using Access 2000.

Thanks!

 

[genomon]

Don't think you can deactivate it, but if you use two (&&) in place of one (&) it will print back in the label as an ampersand and not an underline. It's not a bug, it's a feature...

I wondered why the baseball was getting bigger.
Then it hit me.

 

[KeyserSoze]

Thanks for the reply. I was trying to avoid having to change the data.

 

[genomon]

If you have a chance to play with the data you can use the replace function and replace a single & with &&.

I wondered why the baseball was getting bigger.
Then it hit me.

 

[KeyserSoze]

The Replace function works like a charm and is a much better alternative. Thanks for your help. You get a star.

 

[genomon]

Very cool!
Thanks!



I wondered why the baseball was getting bigger.
Then it hit me.