When I posted the first message about this problem, I was sure that
it was a known problem with a fast solution.

Now that I know it's not, I will go further in the code and try to
find where it fails. I will let you know as soon as I succeed... or
not. :-)

Jason, if this can help, I said in a previous post that in the
GetDisplayText function in TIB_Column, the IsCurrency variable is not
set to true even if I specify 'currency' in column attributes. So,
it cannot execute the code to format to currency.

---
else
if IsCurrency then
Result := FloatToStrF( AsExtended,
ffCurrency,
-SQLScale,
CurrencyDecimals )
---


Obviously, the problem happens before this, it should be set to true.

I hope this will help.


Jocelyn Dionne.

--- In IBObjects@y..., jocelyndionne@u... wrote:
> Hi Jason.
>
> I don't have any DisplayFormat, if you're talking about the
> possibility to enter a format in the field properties tab.
>
> You will understand that I don't want to use a specific format, but
> prefer to use the regional settings preferences.
>
> But if I don't specify 'currency' in the column attributes tab, and
> use a display format, it works very well.
>
> Thanks.
>
>
> Jocelyn Dionne.
>
>
>
>
> --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > I think this is an issue of presentation instead of actual
accuracy
> of what
> > is being stored. Do you have a DisplayFormat setting of some kind?
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com