format detail field at runtime

[mcnewsxp]

i need to format a detail section bound textbox at runtime on a report.
i tried using the condition formatting by entering

IIf(InStr(Me.Result, "+") > 0, "positive", IIf(InStr(Me.Result, "-") > 0,
"negative", Me.Result))

nothing changed

also tried this in the deatil section

Me.txtResult.Properties(40) = IIf(InStr(Me.Result, "+") > 0, "positive",
IIf(InStr(Me.Result, "-") > 0, "negative", Me.Result))

but received an error msg.

how is this accomplished?

tia,
mcnewsxp

 

[mcnewsxp]

i fixed my undinding the text field and simpling assinging the value ala:

txtResult = iff(......)