Invalid Datatype Check

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use the BeforeUpdate event of the textbox to control to validate the data
entered.
 
Back
Top