>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).
If it's not broken, fix it until it is.
My Blog