Delphi DBGrid Format Display Values

Question

I need to format values in a DBGrid to display in a certain format ex '#,##0.00'. Any idea how to do that?

Regards, Pieter

RRUZ · Accepted Answer · 2010-09-01 16:14:31Z

6

you can use the DisplayFormat property of the field to format.

check this sample

TFloatField(YourDataSet.FieldByName('field')).DisplayFormat := '#,##0.00';

edited Sep 1, 2010 at 16:14

answered Sep 1, 2010 at 15:55

RRUZ

137k20 gold badges365 silver badges489 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Eduardo Mauro Over a year ago

Sure, but the event GetText gives more flexibility. For instance, you can use different masks is value is positive or negative.

jachguate Over a year ago

If you need flexibility, but if not don't waste your time writing code for this. For the positive/negative example, if you read the documentation you will notice DisplayFormat support "sections" separated by semicolons, for positive, negative and zeros. So, you can use, for example: begin qOrdersTotal.DisplayFormat := ',0.00;(,0.00);Zero'; end; For more info read docs.embarcadero.com/products/rad_studio/delphiAndcpp2009/…

kludg · Accepted Answer · 2010-09-02 03:20:05Z

5

Each Field in your DataSet has two events: OnGetText and OnSetText. Use event OnGetText of desired fields and use Format function to format the value using a mask.

edited Sep 2, 2010 at 3:20

kludg

27.6k7 gold badges72 silver badges122 bronze badges

answered Sep 1, 2010 at 15:56

Eduardo Mauro

1,5151 gold badge26 silver badges41 bronze badges

Collectives™ on Stack Overflow

Delphi DBGrid Format Display Values

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related