Changing the label on text box

[Guest]

How do you change a Text label based from a Lookup table from another field?
For example.

Label1 : Hello
Label2 : There / You (this is a lookup table)

If a user selects "There" from the lookup table, then Label1 will change to
the word "There". So in the report, it would look like this...

"There : Hello"

And if they select "You", it would look like

"You : Hello" in the report.

Thanks,
Greg

 

[Guest]

Remove the label and use a textbox instead.
Or concatenate the two in the textbox with no label.

 

[Guest]

Thanks! It worked by changing it to a textbox.

Remove the label and use a textbox instead.
Or concatenate the two in the textbox with no label.