DataGridView cell formatting for a whole column

See more:

VB

Hello coders,

I have a DataGridView on a form, that loads data from a database.

Two of the columns (TimeStart, TimeEnd) in this DataGridView are time specific, ie: 13:30 or 09:55

I need some sort of formatting that means the user can only type in 4 numeric characters, then a colon is placed after the first two once the four characters have been typed.

For example:

1. User enters a cell, the value in the cell is highlighted.
2. User types in: 1250
3. Once the last character has been typed, a colon is placed after the second character.
4. User leaves cell, and value stands at: 12:50

Any comments and answers are greatly appreciated, thanks.