>Hi,
>
>I am looking for a possiblity to change the format of a numeric field conditionaly into Format 9999,999.99 + .
>So if i write in the expression box IIF(MYCONDITION = .T., 999,999.99 +, 999,999.99)
>I end up with a row of stars. The txtBox is wide enough and the figure is well under 1 million. Unfortunately I can't use in this particular case the new(SP2) Report*.apps, I have to do with Reportbehavior = 80. Anybody around with an idea how to come to the desired result?
>
>Thanks,
>
>Koen
Can you use TRANSFORM function instead with IIF ?
If it's not broken, fix it until it is.
My Blog