G Guest Mar 2, 2006 #1 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
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
G Guest Mar 2, 2006 #2 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" ÎγγÏαψε:
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" ÎγγÏαψε:
G Guest Mar 2, 2006 #3 FYI, it is done the same way you handle quotes. Using && will display one &, So Me.lblSomething.Caption = "Smith && Wesson" will display Simth & Wesson
FYI, it is done the same way you handle quotes. Using && will display one &, So Me.lblSomething.Caption = "Smith && Wesson" will display Simth & Wesson
G Guest Mar 2, 2006 #4 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
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