Change font color

[LarryH]

I have a field "dues paid through". This field contains a date. Is it possible for a script or calculation that would change the font color in the "dues paid through" field from black to red if dues were not paid on time?

Larry

[LaRetta]

Hi Larry,

You can use a calculation (date) and format this field identically to your DuesPaidThrough field (size and font). Then change the font colour to red. Turn off Allow Entry Into Field (through field format). Change the pen pattern and fill pattern to transparent. Place the calc on top of your DuesPaidThrough field and set the Alignment (drag cursor around both fields) center-to-center.

The calculation would be something like:

Case(DuesPaidThrough <= Status(CurrentDate), DuesPaidThrough)

This will cause the red calc to display if the DuesPaidThrough date has passed (is past due) but will disappear (and therefore display the regular field) if not yet expired.

Cheers,

LaRetta