Recent content by leetie

Thanks mhartman! but I means that if a user enter a string into a field with data type number, MS Access always turn on th standard message: "The value you entered isn't valid for this field...". I can't use the validation rule to solve it. Example, if data type of a field is number (field size...

In MS Access form, how can I create my own message if the user enter a value that not match with the data type of a field in underlying table? Thanks a lot!

Thank you very much!

That is only an example. I only want to know the reason why a control wrong, another controls are wrong too? Please explain me! Thanks!

I'm from Vietnam and my English is bad. In my database, I have only a table named tblEmployees, which contains these following fields: Employee_ID (data type: text), Name (text), Salary (number) and Allowance (number). I build a form bound to this table. In the footer of this form, I have a...