color in a formula 1

[LouieGrandie]

Have the following formula:

if {@PrintExtItmDesc} = "Y" and {PO_PurchaseOrderWrk.ExtendedDescriptionKey} <> array("", "0000000000") then
formula = {PO_PurchaseOrderWrk.ExtendedDescriptionText}+chr(10)+chr(13)& "MTR Required"

I would like the part "MTR Required" to come out in red. Is it possible to code the color within a formula?

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[lbass]

You could use text formatting - "HTML text" (on the paragraph tab->text interpretation), and change the end of the formula to:

& "<font color=red>MTR Required</font color>"

-LB

 

[IanWaterman]

You could use 2 formulae

@Form1
if {@PrintExtItmDesc} = "Y" and {PO_PurchaseOrderWrk.ExtendedDescriptionKey} <> array("", "0000000000") then
{PO_PurchaseOrderWrk.ExtendedDescriptionText}+chr(10)+chr(13)
else ''


@Form2
if {@PrintExtItmDesc} = "Y" and {PO_PurchaseOrderWrk.ExtendedDescriptionKey} <> array("", "0000000000") then
"MTR Required"
else
''

Place the two formulae next to each other in text box and format @form2 to to be red.

Ian