Dear all,

How to write a routine to vlaidate the input of a textbox of a grid say text1?

Check the value of column1, find whether it is exist in a table TableText1.FieldA or not, if it exists, assign the grid.column2.text1.value = TableText1.FieldB, otherwise clear the input of column1.text1, set focus on that cell and force the user to enter the correct input or press to escape.

I have tried to implement by LostFocus Method of grid.column1.text1, however the result is unsatisfactory and the user can left it blank and sewitch to the other cells

With regards,

Ransome