Use of "&" in labels

D

Darren

Hi

Every time I type a "&" in a label, it gets replaced by a "_". I have
checked the auto-correct options, and there is nothing there that seems to be
doing it. To be sure I even added replace "&" with "&". There is obviously a
fundamental reason for it being replaced.. Can anyone enighten me, as its
driving me nuts.

Many thanks,

Darren
 
C

CyberTaz

The ampersand is used by Access as an operator. Operators are illegal
characters in labels.

HTH |:>)
 
L

Lynn Trapp

The ampersand key is used to create a hotkey. If you need the ampersand to
actually appear in your label, then you type it twice in succession:

Smith && Company will display as Smith & Company.
 
J

Jeff Conrad

Use two of them together.

"This && That"

....will display as This & That in the label.
 
L

Lynn Trapp

The ampersand is used by Access as an operator. Operators are illegal
characters in labels.
Click to expand...

There's really nothing "illegal" about the use of an ampersand in a label.
However, it is reserved for a special use. It is designed to create a hotkey
for a button. Therefore, to get it to display as an actual text item, the
convention is to type it twice -- &&.
 
D

Darren

Many thanks to you all for replying..

This small amount of information just made my day a lot easier :)

Thanks again,

Darren
 
D

Darren

Many thanks to you all for replying...

This small amount of information has made my day a lot easier :)

Thanks again,

Darren
 
Top