Format text in formula???

[jaguar00]

I have the following formula but I want the text 'NO CITY LISTED' to show in red. How do I do this when it's already in an IF-THEN-ELSE statement? I've looked everywhere, but no luck.

IF ISNULL ({tblProjects.CityName})
THEN {tblProjects.ProjectName} & chr(13) & 'NO CITY LISTED, ' & {tblProjects.StateAbbr}
ELSE {tblProjects.ProjectName}&chr(13)&{tblProjects.CityName}&', '&{tblProjects.StateAbbr}

Oh...I'm using CR10 w/SQL server.

Thanks for all help!!!

 

[synapsevampire]

Right click the formula and select format field->Font->X2 next to Color and place:

IF ISNULL ({tblProjects.CityName}) THEN
CRRED
ELSE
CRWHITE

-k

 

[lbass]

You can use HTML tags, as in:

IF ISNULL ({tblProjects.CityName})
THEN {tblProjects.ProjectName} & chr(13) & '<font color = red>'+'NO CITY LISTED, '+ '</font color>' & {tblProjects.StateAbbr}
ELSE {tblProjects.ProjectName}&chr(13)&{tblProjects.CityName}&', '&{tblProjects.StateAbbr}

You would then have to format the formula->format field->paragraph formatting->text interpretation->HTML text.

-LB

 

[jaguar00]

lbass...WORKED LIKE A CHARM!!!!!!!
You're my hero!!
Thank you!