DBGrid column format currency

Hi all,

I have tried everything and searched everywhere but I must be overlooking something. I have a DBgrid that is linked to a query. One of the columns needs to show currency and the field is float. I am using Delphi XE.

I have tried the following but Delphi XE doesn't have the displayformat property.

dbgrid1.colums[NumberOfColum].field.displaymask := '#,##0.00';

//variante 1
procedure TForm1.Button1Click(Sender: TObject);
begin
  TNumericField(dbgrid1.Columns[0].Field).DisplayFormat := '#,##0.00';
end;

//variante 2
procedure TForm1.Button2Click(Sender: TObject);
begin
  TNumericField(dbgrid1.DataSource.Dataset.FieldbyName('FloatFieldName')).DisplayFormat := '#,##0.00';
end;

Select allOpen in new window