Label Bound to another Label

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dolphinv4 - 29 May 2008 11:54 GMT

Hi,

is it possible to bound a label to another label with a lookup, ie,

Label1 = AXY
Label2 = 123 whereby there is a table showing that AXY belongs to 123?

Thanks,
Dolphin

Reply to this Message

Douglas J. Steele - 29 May 2008 12:59 GMT

You can't do it dynamically, but you can in code:

Me.Label2.Caption = "123 whereby there is a table showing that " &
Me.Label1.Caption & " belongs to 123?"

You might be better off using text boxes than labels. Then, you can make it
dynamic. Make the ControlSource property of the second text box equal to

="123 whereby there is a table showing that " & Me!Text1 & " belongs to
123?"

(including the equal sign)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
>
[quoted text clipped - 5 lines]
> Thanks,
> Dolphin

Reply to this Message