change font color in field 1

[ajdesigns]

Hi.
I have to change the color of the font in a field if that field contains certain letters at the end.
eg.if the field value was 1234cd I want this to be red so it is highlighted.
if the field value was 1234 I would like the font color to remain black.
I realise you need to use wildcards but I have tried "*cd" and "????cd"
but niether works please could someone help.
thanks
Andrew D.

 

[lbass]

I think you could just go to format field->font->color->x+2 and enter:

if right({table.field},2) = "cd" then crRed else crBlack

-LB