Instead of using event code to validate each field as it is edited, why not wait
until the user indicates (by clicking an 'OK' or 'Add record' button or
whatever) that the data should be appended to the list? Then validate every
field before appending the data. I do this with a single (lengthy) validation
function that notifies the user of the first error encountered and ultimately
returns TRUE if no errors were found or FALSE if any errors were found. Also, if
the user quits the session (closes the form, etc.) before attempting to commit
the record, no effort is spent validating data that won't be used.
Hope this helps,