Hello,

I am using the formula below to change the font color when a field is lower case. It works, but only when the entire field is lower case. I need this to work even if the field contains only one lower case.

Any help much appreciated.

if instr(lowercase({table.field}),{table.field},0)= 1 then crred else crblack