Format Column in Datagrid Tablestyle Collection

[Moishe]

Hi All

I have a column (Time) in the tablestyle collection I want to format it to "00:00" when user enter 1100 it woud format it to 11:00 and also validate if it is a valid input?

 

I tried doing it in the designer propeties for the format something like format: "00:00"

but it didn't work.

 

Thanks for your help.

[georg]

Moishe

 

1. Declaration:

Dim colTime As New DataGridTextBoxColumn()

2.Mapping and Formatting

colTime.Mapping = "Time"
colTime.Format = "HH:MM"

3. Add to the DataGrid

MyDataGrid.TableStyles(0).GridColumnStyles.Add()

 

I think these are the core elements of what you need to do, but I haven't tested the "HH:MM" bit.

 

georg