DisplayFormat - TCurrencyField

dkrollCTN · 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?

Thanks,

David

Dimon · 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.