Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional html formatting on a field in a formula 1

Status
Not open for further replies.

tmccoy1

MIS
Jan 24, 2013
15
US
This works on static text, but when using an actual field it just prints the field name on the report, bolded and in red. Any suggestions on fixing this in Crystal Reports 2008?

IF {field_code} = 'Y'
THEN
"<html> <font color = red> <b> {field_value} </b> </font> </html>"
ELSE
{field_value}

Thanks in advance.
 
Try:

IF {field_code} = 'Y'
THEN
"<html> <font color = red> <b>" & {field_value} & "</b> </font> </html>"
ELSE
{field_value}
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top