Append(vb Cr Lf) 'Get our year count errors' If o Inv Year.To String()) Then 'show a message box or whatever...Add(i 1) bln Err Found = True End If End If Next 'If errors found, lets append them to our message' If bln Err Found Then o Error Msg.At run time, if the validation fails, the Data Grid View displays a red exclamation icon in that cell (see below).If it is less than five characters, you set the Error Text property of that cell to some error message.I currently have a data grid that is holding the information from an Access table.Cells("Zip Code").value = new Zip Valuethe new value doesn't get accepted. You may be able to cancel the event, instead of setting the cell value.
I'm not sure what's actually happening behind the scenes but it seems like the validating event takes the value entered before it gets sent to the datagridview, validates it, then passes it to the datagridveiw.The details in the database are employee details e.g.What I need is to be able to validate the data that's being entered for data type, presence and extreme data, but I have no idea what to do.Private Sub Validate Year() Dim o Inv Year As New Collection Dim o Error Msg As New System.String Builder Dim bln Err Found As Boolean = False 'Loop through year column and check for number, if blank skip' For i As Integer = 0 To dgv Intervals.I could easily do this using Cell Value Changed but I don't want the user to be able to leave the cell if the zip Code is not valid. Thanks Perrin you may have to reference it through the sender obj that is passed. this may be the datagrid itself or the datagridviewrow, you will have to msgbox a sender. Then you can code directly against the sender, and that should work. -Sometimes the answer to your question is the hack that works Thanks for the suggestion,sender. Get Type returns "Data Grid View" so I tried: Msg Box(CType(sender, Data Grid View). I could use the Cell Leave, and I think that's what I have done in the past, I just thought it would be cleaner if I was able to do it from the Validating event. To String Your requirements: I could easily do this using Cell Value Changed but I don't want the user to be able to leave the cell if the zip Code is not don't you just have a Cell Leave and have a flow like:if column = Zip Code 'validate zip if valid 'exit sub else 'set focus to current cell end ifend_ifthen do all you other processing in the Validating -Sometimes the answer to your question is the hack that works I tried your code and it works fine but it changes the value of the textbox but it doesn't change the value of the cell.