Results 1 to 3 of 3

Thread: Form (2003)

  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form (2003)

    One of filed in the form is "B&P." But form doesn't show " B&P" instead of "B_P", also it happens in the report. How can access show the "&?"

    Thanks

    Regards

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form (2003)

    Try setting the caption of the label to B&&P. A & character specifies that the next character can be used as an accelerator key; the next character will be underlined. Using && tells Access to treat the & as a literal character.

    (It is not a good idea to use spaces, punctuation and special characters such as & in the name of database objects, fields, controls etc. - as you have found, it can lead to problems. You can always set the Caption to the text you want to display.)

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form (2003)

    Thanks a lot.

    It works.

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •