DisplayFormat - TCurrencyField

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 1
Joined: Thu 04 Sep 2008 19:55

DisplayFormat - TCurrencyField

Post by dkrollCTN » Thu 04 Sep 2008 19:58

Hello all,

I'm using SDAC 3.7 in Delphi 2006 Pro. I'm editing the DisplayFormat of a currency field in a MSQuery. I normally use $###,###,##0 for the format, but if the value is negative, I want it to be enclosed in parentheses and NOT have a minus sign.

How can I do this in the DisplayFormat?



Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 08 Sep 2008 10:26

You can't do it with the DisplayFormat property. To display value in this format you should process the TField.OnGetText event.

Post Reply