datagrid column format 1

[naitx]

Hi,


How can I format Datagrid Column into percentage?

Datagrid.Columns("fieldname").DataFormat = ???


Thanks in Advance

 

[SBerthold]

To use the .DataFormat you need to first define a StdDataFormat object and set the .DataFormat to it.

Form simple formating, an easier method would be to use the NumberFormat property.
With this you can define formats the same as you would with the Format$() function:

'Percent:
DataGrid.Columns("SomeNumericField").NumberFormat = "Percent"

'Upper case:
DataGrid.Columns("SomeTextField").NumberFormat = ">"

'Date
DataGrid.Columns("SomeDateField").NumberFormat = "yyyy-mm-dd

 

[naitx]

Thank you SBerthold !!