I have a datagridview (bound) which works fine as long as the users "accepts" each cell they type in by pressing the tab key. However, when they click in another cell before pressing "tab", the value is visible in the cell on the screen but is not actually there.
What I mean with that, is that on the screen it shows for example '5' in the column, but when I check the cell value it shows as an empty cell (and a calculation based on this cell value does not see the value either).
I have tried validating the cell content (but as it is blank, there is nothing really to validate) and I have tried to set the cell value to blank if there is nothing in there as a cell leave event.
Any idea on why this is happening and how I can make sure that a cell value is "accepted" before the user moves out of the cell by a mouse click? If you try the same in say Excel, it "accepts" the value even if the user does not press tab or enter to get out of the cell.
Help appreciated, thanks very much.