I have developed an Access application that gathers data from a data entry
staff; it then generates and sends reports to management. Occasionally,
invalid entries (text instead of number etc.), cause data type mismatches
preventing the reporting. How can I programmatically check for these errors
and delete the bad records before the reports are generated?
Thanks
Alex
Ken Snell [MVP] - 09 Feb 2005 20:55 GMT
Use the BeforeUpdate event of the textbox to control to validate the data
entered.

Signature
Ken Snell
<MS ACCESS MVP>
>I have developed an Access application that gathers data from a data entry
> staff; it then generates and sends reports to management. Occasionally,
[quoted text clipped - 6 lines]
>
> Alex