Like Formula, picks up some, not all fields

[jrhessey]

I'm trying to figure out what I've done wrong, but can't seem to make sense of it. I'm trying to conditional formatting of fields that have certain text in a description.

Here is the formula:

if {SO_24CRWPickingSheet.ItemDescription} like "Discontinued" then crBold else
if {SO_24CRWPickingSheet.ItemDescription} like "discontinued" then crBold

Now if the Description field has Discontinued and only Discontinued then it works, but it has anything else after Discontinued, then it doesn't do any formatting. I'm using CR 8.5.

 

[lbass]

Add wild cards and address the case issue, as in:

if ucase({SO_24CRWPickingSheet.ItemDescription}) like "*DISCONTINUED*" then
crBold else
defaultattribute

-LB

 

[synapsevampire]

Try:

if UCASE({SO_24CRWPickingSheet.ItemDescription})like "*DISCONTINUED*" then
crBold
else
crregular

-k

 

[kristal9]

put an * (asterick) after discontinued. that should do the trick... it's simply wild carding