Invalid Datatype Check

A

Alex

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
 
K

Ken Snell [MVP]

Use the BeforeUpdate event of the textbox to control to validate the data
entered.
 
Top