Changing the label on text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Remove the label and use a textbox instead.
Or concatenate the two in the textbox with no label.
 
Back
Top