HereÕs one for you:

How can I create a conditional that will change the color of the text in a
displayed field, depending on what the field value is?

My database Ôprojects.fp4Õ has a field ÔOpen_ClosedÕ, which indicates
whether a project is open or closed. When a user adds a new project to the
database, the field defaults to ÒOpenÓ. Later, when the project is finished,
the project manager sets it to ÒClosedÓ. What I would like to happen is when
the default value ÒOpenÓ displays on the response page, the font colorÒredÓ. But when the value is set to ÒClosedÓ, the font color=ÓblackÓ on the
response page.

Any ideas?

--Jay