Hi Jorge,
Tried that :( I would not say it's driving me crazy otherwise...
Still doesn't do what I want!!!!!!!
>Hi, why don't you just format the field in the report with $999,999.99 or whatever fits your needs, this way it will work every time regardless of regional settings.
>
>>Hi everybody,
>>
>>I'm designing a report. I added fields in the body section, say, mortgage. I set format to currency and display blank if 0. I want it to be $123,250 (, separates thousand). Instead I have $123250.000000000 I checked my region settings, they are ok. I tried set decimal to 0 and set fixed on/off. Nothing helped. What else could it be?
>>
>>Thanks in advance.
If it's not broken, fix it until it is.
My Blog