Results 1 to 4 of 4
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    2,097

    How to use the ampersand character within a label control.

    I want to use the ampersand character "&" within a label. It shows correctly when editing the text but then when the form displays it is replaced with what looks like an underscore character. How do I allow A2003 to properly display the character?
    Thanks,
    Bill

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    The Ampersand character is used to denote a Hotkey. It places an Underscore under the letter that follows it. If the Caption of a Command Button, for example, is

    &Pop

    using the Hotkeys

    <Alt> + <P>

    is the same as clicking on the Button.

    To just display an Ampersand, double it up:

    Robbins && Sons

    will display as

    Robbins & Sons

    Linq ;0)>

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    2,097
    Thanks. And, wouldn't you know it that in one of the uses in the label it is referenced as "&", so of course the 2nd quote is underlined. I.e., Robbins "&&" Sons displays as Robbins "&" Sons

    Thanks again,
    Bill

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Glad we could help!

    Linq ;0)>

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Ampersand in labels or on forms
    By Malcolm41 in forum Access
    Replies: 4
    Last Post: 07-15-2012, 09:22 PM
  2. Replies: 5
    Last Post: 05-18-2011, 11:02 AM
  3. Text Box control and character limit?
    By Bigdoggit in forum Forms
    Replies: 2
    Last Post: 03-29-2011, 10:05 AM
  4. Replies: 4
    Last Post: 10-07-2010, 09:42 AM
  5. Replies: 1
    Last Post: 04-29-2010, 05:15 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums