How to change the name of a label

L

louonline

Sorry if I have posted this twice, there seemed to be a problem with my
first post.

Hi,
Can someone tell me how to change the name of a Label depending on
what's entered in ANOTHER Field?

Like this.....
if amont tendered in the [FIELD_Amount_Tend] >= [FIELD_Total] then
Label_Name associated with the [FIELD_Change] = "Change"

if amont tendered in the [FIELD_Amount_Tend] < [FIELD_Total] then
LABEL_Name associated with the [FIELD_Change] = "Amount Owng"

Total..............$50.00
Amount tendered........$60.00
Change......................$10.00

------------------
Total..............$50.00
Amount tendered........$20.00
Amount Owing...........-$30.00

Thank you for any help.

Regards,
Lou
 
G

GGill

Try this;

If [FIELD_Amount_Tend] >= [FIELD_Total] then
LabelName.Caption = "Cnange"
End if
 
L

louonline

Thanks Gill,
sorry to be so dense, but where do I put this code?
In the LabelName CaptionProperty or somewhere else.

Regards,
Lou
 
Top