473,320 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Problem with DataGridView and Cancelling NEW ROW entry after messup

Hi,

I have a DGV and I go to the NEW_ROW and start editing in there ( I
only have 1 COLUMN), I enter a value, and try and take focus off the
CELL by going to another control on the form or another CELL. The
CELL_VALIDATING event kicks in and Says DATA = BAD so it does'nt let
focus shift. So I decide I don't want that NEW_ROW anyway and want it
gone, so I press ESC and wish it disappeared but it does'nt.

Please if someone could tell me how I can... (After the cell has failed
validation and the little error icon is showing, and the focus cannot
shift)... press ESC and make the NEW_ROW disappear, after all I havent
saved it yet.

I have been trying to work this out for ages, please help me!

Thank You
Asif

Jan 12 '07 #1
1 1189
Hi all,

No worries, I think the problem is solved, I read somewhere that
CellLeave runs before CellValidate, this has helped me, should be no
problems now.

Thanks

Jan 13 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Eric | last post by:
What's the best way to cancel the new record when doCmd.GoToRecord , , acNewRec is executed and before the new record is actually written to the database. I'm maintaining an existing Access 97...
3
by: Danny Nielsen | last post by:
Hi I am having trouble figuring out how to use combobox in a datagridview. What seemed to be a simple task turned out not to arrghh. I have a dataGridView with 4 columns, one of them is column...
1
by: George | last post by:
Hi, Does anyone know how to simulate the 'escape' key functionality for cancelling add ing a new row in DataGridView. I have attempted to use CancelEdit(). They seem to only remove/dispose...
3
by: Jim Devenish | last post by:
In my application vehicles arrive and depart from a workshop. The ArrivalDate and the HandoverDate are each entered. Sometimes the person who should enter the arrival date forgets to do so. ...
3
by: twigboy | last post by:
Hi, I know this question has been asked many many times and I think I found the answer to this question to be to rebind the dataset. But my question is where do I do this. I have a main form that...
0
by: Mohanss | last post by:
Master & Transcation table Datagridview serialno increement with automatically to Entry to Entry not like this 1st entry 123 2nd entry 456 I want 1st entry 123
1
by: Jeff | last post by:
Hey ..NET 2.0 I've created a User Control which contain a DataGridView. This User Control is displayed on a TabPage. This TabPage is added to the TabControl during runtime. The problem is...
1
by: Roach | last post by:
VB.NET 2005 2.0 Framework application is using a DataGridView for SQL data access and user data entry. As part of exception/error handling, the app wants to advise the user when he/she enters a...
9
by: Miro | last post by:
My current headache is proper is with the datagridview I am starting to realize that a DataGridView within vs2008 is not as 'robust' as a 'textboxfield' by default for example. Example: A...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.