>Hi All !
>
>Can somebody tell me how to change default text "Invalid input" (when valid return false). ?
Using the Valid() event for validation has some problems. For instance, the user may not even select a certain control, and leave it empty.
I suggest you consider the following alternative: Do all validation when the user tries to save the record. Show the user a list of violations.
This is especially easy to maintain if you use a special table to store rules, and the corresponding error messages. If you are interested, I can post the corresponding functions, and the table structure.
However, you might still get "invalid input" if you try to input an invalid date, like 30/Feb/2002. I don't know how to intercept this.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)