format detail field at runtime

M

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
 
M

mcnewsxp

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

txtResult = iff(......)
 
Top