Format Text based on Field

[Helo]

Hi

Anyone know if it's possible to format text based on what's in a field?

For example:

In my layout I have a field called "status." At the top of the layout I'm using <> to display "Complete," "Pending" or "Working," depending on which is in the "status" field. I want the text in <> to be red when the field for that record is populated with "Working," yellow when populated with "Pending," etc.

By the way, does anyone know what that function of displaying text from a field using << >> is called?

[Roy Osborn]

<>

Yes, look into the text formating functions and the case function. try something like this:

cDisplayStatus=

case(status="whatever";text Format here; status="something else": text format here;) etc