Devart Forums

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

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