Using an & in a label on a form

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

Guest

How can I use an ampersand (&) in a label on a form? When I type it, it is
displayed as an underscore on the form. I am using Access 2002.

Thanks
 
Dear friend,

Instead of adding a label add a text box and type the following:

="Your Label text & SomeMoreText"

Remeber Enable = No, Locked = Yes and also the formatting in order to be
seem as a label (transparent border and fill color)

George


Ο χÏήστης "Lori" έγγÏαψε:
 
FYI, it is done the same way you handle quotes. Using && will display one &,
So

Me.lblSomething.Caption = "Smith && Wesson" will display Simth & Wesson
 
Thanks to all. That was simple! To store a single "&" in the field and then
display that value in a lable I just used:

label.caption = replace (fieldValue,"&", "&&")

Worked great thanks to the assistance.

B
 
Back
Top