Instead of using a text box in column1 try to use a combobox. Set the Style property to "2 - Dropdown list" and the RowSourceType to "2 - Alias" and RowSource to "TableText1.FieldA". That way the user is only allowed to enter valid values.

Hope this helps.

Aloha,

James

>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