>>Naomi,
>>its ok for me to receive a reply after your session. Anyway it is 23:30 already in Holland.
>>I would like to have my number formatted to 999,999.99 + only if a condition is true, otherwise the format will remain 999,999.99.
>>So if condition is true it would show as e.g. 78,796.00 + and if condition is false it could be 67,560.00 or (in case it is negative -67,560.00)
>>Bye for now,
>>will read you tom.
>>
>>Koen
>
>So, what again is the problem?
>
>iif(myCondition, alltrim(transform(myNumber, "@ 999,999,999.99")) + " + ", transform(...))
>
>Check transform command for details, I write from memory (no VFP here, of course).
Funny, after I re-read the beginning of the thread I see that I definitely was not explicit in my suggestion which led to all the confusion...
If it's not broken, fix it until it is.
My Blog