Setting a DBGrid column format in Delphi

Question

I am using a DBGrid component in delphi. I wonder how I can set the format of a column. I have real values that I want to be displayed as currency in the grid.

Someone knows how?

Answer 1

The first port of call is the DisplayFormat of the data field in the database itself.

Answer 2

(1) You can Set the DisplayFormat of Field.
(2) You can change too, in the OnGetText event. At this you can do more complex operation with the value.

Excuse-me for my bad english.

Neftalí.

Answer 3

If you don't add the fields to field Editor list you can get the formating by code as :

TFloatField(MyQuery.fieldByName('MyField').DisplayFormat := '0.00';

if you don't want to show the zeros replace '0.00' with '#.##';