BeforeUpdate event occurs for a text-based control or for the form itself
EditByBSEditor: This Access VBA class will attach to any form and trigger data validation code to automatically execute when the BeforeUpdate event occurs for a text-based control or for the form itself. This allows you to keep all your validation code in one class, and lets you use the same validation code for one field on different forms. you can free download Form Validate Class 1.0 now.