Can I change a Label's Caption?

  • Thread starter Thread starter Bill Johnson
  • Start date Start date
B

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?
 
Replace the label with a text box and set its control source property to
=IIf([AreaType]="Sq Ft","Total SqFt","Total Acres")
 
Thanks. Thats a good solution - a lot easier than the direction I was taking
myself.
 
Back
Top