Is there a way to do field validations in a grid with out losing focus to the grid. I have set up a grid and and in the valid of the text field I have added code to test whether the fiels now holds valid data for that field and if not returns back to that field for proper input. When the form is run and I type in an invalid value, my messagebox or wait window appears, I am returned back to the field, but I can not enter a new value or leave the field. I set the grid as readonly to not allow edits and when a command button is pressed, it turns off the read only to the grid to allow edits or additions.

this is the code I have in the valid of the textbox of the column in my grid.

If !this.value $ 'MIS FED'
wait window 'Must Be "FED" Or "MIS"' timeout 1
return(0)
endif

Am I doing this right or is there something I am missing?

TIA
Ron