I have a database in Access that I want to display it in a Datagridview which consists of a key, date, time, and 2 more Comboboxes filled again from other tables in the same Access In the date and time fields I've put a mask to be easier to place them. If I change a value in Combobox I have in Datagridview if not the first time the second definitely stop showing the masks in the areas of time and date. The comments are welcomed Table1 ID Col1 Date Time Col4 1 1 08/04/2013 1 2 2 09/04/2013 2 3 3 10/04/2013 3 4 4 11/04/2013 4 5 5 12/04/2013 5 6 6 13/04/2013 6 7 7 14/04/2013 7 Table2 tbl2_ID tbl2_Desc 1 Desc1 2 Desc2 3 Desc3 4 Desc4 5 Desc5 6 Desc6 7 Desc7 Table3 tbl3_ID tbl3_Desc 1 Desc A 2 Desc B 3 Desc C 4 Desc D 5 Desc E 6 Desc F 7 Desc G And the code i use is this Imports System. Ole Db Public Class Form1 Dim con As Ole Db Connection = New Ole Db Connection("Provider=Microsoft. OLEDB.4.0; Persist Security Info=False; Data Source = C:\Test.mdb") Dim cmd As Ole Db Command Dim ds As New Data Set Dim da As Ole Db Data Adapter Dim cmb1 As New Data Grid View Combo Box Column() Dim cmb2 As New Data Grid View Combo Box Column() Private Sub Bkpdwn_D_List_Load(By Val sender As Object, By Val e As System. Load Call fill_cbos() Call fill_data Grid() masked Text Box1 = New Masked Text Box With masked Text Box1 . Visible = False End With masked Text Box2 = New Masked Text Box With masked Text Box2 . Conversely, if not tampered Comboboxes then all the masks and the time and date work fine. Cancel = true (which would be awesome) is not available in this event.Either way, I need the focus to remain in the cell instead of going to the next row when I hit Enter. Data Grid View Cell Validating Event Args) Handles Data Grid View1. Visible = False Else Msg Box("Wrong Date") masked Text Box1. Add(masked Text Box2) End Sub Private With Events masked Text Box1 As Masked Text Box Private With Events masked Text Box2 As Masked Text Box Private Sub Bkpdwn_D_Data Grid View_Cell Begin Edit(By Val sender As Object, By Val e As System. Data Grid View Cell Cancel Event Args) Handles Data Grid View1. Column Index = 2) Then Dim rect1 As Rectangle = Me.
That is OK, but what I want is to override that behavior when the datagrid cell's content matches a certain condition (in my case, I am checking for duplicated values in a column).
Here's the code I've come up with so far: When I close the Message Box (which shows exactly when the condition is met), the focus goes to the row below.
As I said, I would like it to remain in the cell that has the duplicate content.
I just tested with ' Cell Enter' event and I found that it works as you expect.
Displaying a Combo Box in Cell Frequently, besides displaying text in a cell you may want to display a drop-down list box to allow users to select from a list of pre-determined values.