In grid edit mode, very limited validation is possible. If a field is mandatory (at the table level) and it is empty when saving, you can't save. Other than that, it will allow all other changes. To overcome this situation, I have come up with a work around. Not perfect, but something is better than nothing. I have a formula-text field "Error Message" which I use to populate with a message if something is wrong. This field will be on the grid edit report and every other report. The hope is that someone or the other will notice this and fix the data to get rid of the error message. When you are in form-edit mode, I can use the same field and abort the save if the error message field has contents. Having said this, I am interested to see if anyone else has other ideas.
