"&" displays as "_" at form view In access

[RoyS1031]

I type "Invoices & Orders" in a label on a Swithcboard in design view. When
I go to Form view or even give focus to anything else besides the label, the
ampresand turns to an underline "_". How do I prevent this so the "&"
displays in Form vire?

 

[John W. Vinson]

I type "Invoices & Orders" in a label on a Swithcboard in design view. When
I go to Form view or even give focus to anything else besides the label, the
ampresand turns to an underline "_". How do I prevent this so the "&"
displays in Form vire?

Use &&.

The ampersand character in a Label or Caption indicates that the subsequent
character is a "hotkey" - e.g. a Command Buttion caption containing E&xit
displays with the x underlined, and pressing Alt-X fires the "click" event of
the button. What's happening is that "& " is giving you an underlined blank.

To get a single ampersand, just double the ampersand.

 

[RoyS1031]

John,

Thanks so much. it works great and is so simple.

It feels really humbeling to be able to do some of the deep coding I do then
get hung up on something as simple as this. I guess we all are not as
infallabl as we would like to think.

RoyS1031

 

[John W. Vinson]

I guess we all are not as
infallabl as we would like to think.

LOL!!!!!

I *hope* the missing e was deliberat.