Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Concatenating Values in a Report Text Box (2000)

    What kind of expression can I enter into the text box "MediaDiEnergia"(see attachment) so that I can concatenate the value of the numeric field "MediaDiEnergia" with a literal similarly to the text box to its right in which I've succeeded in concatenating a text field([Perc]) with a literal(" MW)?
    I tried typing
    <font color=red>=Cstr([MediaDiEnergia]) & " MW" </font color=red>
    and
    <font color=red>=Format([MediaDiEnergia], "#,##0") & " MW"</font color=red>
    in the Control Source box of the Property sheet but I get #Error in the report print preview.
    <img src=/S/help.gif border=0 alt=help width=23 height=15>
    Attached Files Attached Files

  2. #2
    New Lounger
    Join Date
    Jun 2002
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenating Values in a Report Text Box (2000)

    If you create a report, then modify a Control Source for a text box, you often need to change the name of the text box. I just add a number or something to the end of the name of the text box in the properties window.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Perfect!

    You're great. Thanks

Posting Permissions

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