Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2006
    Thanked 0 Times in 0 Posts

    combine fields (2003)

    On a report: An unbound field control- I want to combine a field with a label. Combine fields would be: =[field1]&" "&[field2]. I want to combine =[field1] &" "& label2. Anyone know code to perform this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: combine fields (2003)

    What do you mean by 'a label'?

    If you mean fixed text, you can do that by concatenating with the fixed text, enclosed by quotes. For example:
    =[Field1] & " " & "units per month"
    or even
    =[Field1] & " units per month"
    If you mean the caption of a label (control), that can't be done in the control source of a text box. You'd have to use VBA code to fill the text box.

Posting Permissions

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