Hi
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
views:
169answers:
2
+2
A:
you can use the DisplayFormat property of the field to format.
check this sample
TFloatField(YourDataSet.FieldByName('field')).DisplayFormat := '#,##0.00';
RRUZ
2010-09-01 15:55:20
Sure, but the event GetText gives more flexibility. For instance, you can use different masks is value is positive or negative.
Eduardo Mauro
2010-09-01 15:57:34
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 http://docs.embarcadero.com/products/rad_studio/delphiAndcpp2009/HelpUpdate2/EN/html/delphivclwin32/DB_TNumericField_DisplayFormat.html
jachguate
2010-09-03 06:23:18
+2
A:
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.
Eduardo Mauro
2010-09-01 15:56:28