Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Caption concatenation (Access 2000)

    Concatenation in the caption of a command control

    I refer to my question about the Message box giving the value of the list box in my previous thread and i received an excellent solution by Charlotte from the
    present Forum. It states:
    Just concatenate the reference to the listbox value into the prompt for your message box.

    " Invoice number " & Forms![F1]![list].Value & " has been updated."

    Access shows no error, however the number of the invoice does not appear on the command control. Why i cannot see the number of the invoice on my command

    control ? If it is possible, the user will always has in mind the number of the invoice Perhaps it is not possible

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Caption concatenation (Access 2000)

    Where are you trying to build this caption? You'll need to set the caption property in code to get the result you want.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Caption concatenation (Access 2000)

    Thank you for your advices.I think i owe you an appreciation for the advices you have given.After your reply i have made a code
    that really works.it is the following
    Me![CmdDeleteInvoice].Caption = " Invoice number " & Forms![FOrderInformation]![list].Value & " has been updated."


    And there the number of the invoice can be seen.I want to that you for that.

    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
  •