Stawberry field

[jofftan]

If this possible to have filemaker set filedtype text in red each time it check if a due date field is smaller or equal rhan today.

Kind of:

If [duedate] than Today

set the fieldtype to red

??

[-Queue-]

No, but you can create that calculation field with Due Date as its result, and put it on the layout on top of the Due Date field, set it with a clear fill pattern, and format its text as red. When the calculation is valid, the red field will display over the normal Due Date field. When it's not valid, you'll only see the normal one.