Hi folks, I've been teaching myself Access programming and am new to this forum. I have looked here and elsewhere for a problem but have not found a solution, hoping someone here can help.
In a form control, I am doing a number of data checks and generating appropriate error messages, using VB in the "on exit" event. The field I am checking is declared as data type number in the underlying table. If the user mistakenly enters text, Access generates an error "The value you entered isn't valid for this field." I want to change that default error message. I have learned how to change other default error messages, but I can't figure out how to trap and change this one. Note -- I don't want to check for the error in the form, because there are a dozen or so controls in the form where I need to do this check.
I would be most grateful for help.