Hi.

I have a DBGrid bounded to an Access database table. The user is allowed to input values in some cells if necessary. For instance, if all the cells in a certain column must only have a numeric input less than a byte (255), how can I validate the input in that cell? I tried inputting values such as 256, or a string, and an error message was displayed saying "Data type conversion error" which was given automatically by VB. What I want to do is to catch the error and display a customized error message. How can I do this?

I also noticed that automatic validation only occurs when I leave a cell using the Down arrow or by clicking another cell. If I use the other arrows or press Enter, nothing happens. How can I prevent the user from leaving a cell if his/her input is wrong?

Thanks for the info in advance!