crystal reports - Conditional Formatting Char vs Numeric in String -

i'm trying simple formatting in crystal reports like:

string:     john smith 212-212-2121

where a-z 1 color , 0-9 different color

i tried

 if numerictext ({mystring})    crred else crnavy

any ideas on how ?

as far i'm aware, can't have multiple colors in single string.

you've got couple of ways of doing this, they're both kind of clunky, , string as-is need either parsed or reformatted.

split string 2 separate formula fields. color name field appropriate color, , phone number field appropriate color, , stick both of these fields textbox field. should crudely drawn example:

[ [name formula field] [phone formula field] ]
change string use html, , format textbox use text interpretation of html. can't work 100%, though, because crystal reports supports html.

in case, new string like:

< font color='red'>john smith< /font> < font color='blue'>212-212-2121< /font>

Detect