Datagridview: limit number of characters

[roblew1]

Hi,

I have a simple application with a datagrid. It just gives a list of selected employees, and the user then enters a grade in a column for each employee. I have created the application which is fine, but a user has requested that when you enter a grade (that is valid), they want the system to move to the next employee.

What i need: only allow 1 character in a datagridview cell and if that charcter is valid (i.e. characters A to F) then to move to the next cell below.

Thanks

[kenobewan]

Welcome to TSDN. What do you plan to do if it is not valid? Are you looking for validation or limiting of the field?

[roblew1]

If it is not valid the cell doesn't change.
I currently use cellvalidating and cellvalidated procedures to achieve this when the user moves to the next cell (by the enter key or down arrow), but these events don't kick off until users manually move out of the cell

[kenobewan]

Please post your relevant code. Thanks.

[roblew1]

Here is may code for those events:

Private Sub DGRegister_CellValidated(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DGRegister.CellValidated
DGRegister.Rows(e.RowIndex).Cells(e.ColumnIndex).V alue = Microsoft.VisualBasic.Strings.UCase(DGRegister.Row s(e.RowIndex).Cells(e.ColumnIndex).Value)
End Sub

Private Sub DGRegister_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEve ntArgs) Handles DGRegister.CellValidating
Dim ValidEntry As Boolean
Dim txtCell As String, txtOldCell As String
Dim iC As Integer

ValidEntry = False
txtCell = UCase(e.FormattedValue)
For iC = 0 To iMaxCodes
If txtCell = Microsoft.VisualBasic.Strings.UCase(KeysAllowed(iC )) Then
ValidEntry = True
Exit For
End If
Next
If Not ValidEntry Then
e.Cancel = True
End If
End Sub