Use of "&" in labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
The ampersand is used by Access as an operator. Operators are illegal
characters in labels.

HTH |:>)
 
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.
 
Use two of them together.

"This && That"

....will display as This & That in the label.
 
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 -- &&.
 
Many thanks to you all for replying..

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

Thanks again,

Darren
 
Many thanks to you all for replying...

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

Thanks again,

Darren
 
Back
Top