Can I change a Label's Caption?

[Bill Johnson]

I have a label on a form that changes depending on the value of a field
called AreaType.

If AreaType is Sq Ft, then a label for Total Sq Ft is Total SqFt. If
AreaType is Acres then a label changes to Total Acres.

Can I get a label on my report to do the same thing based on the value in
AreaType?

 

[RonaldoOneNil]

Replace the label with a text box and set its control source property to
=IIf([AreaType]="Sq Ft","Total SqFt","Total Acres")

 

[Bill Johnson]

Thanks. Thats a good solution - a lot easier than the direction I was taking
myself.