how to validate ms access textbox using button click event?
Open a form or a data access page in Design view.
Make sure the Control Wizards tool in the toolbox is not pressed in. This turns off the wizard.
In the toolbox, click the Command Button tool.
On the form or data access page, click where you want to place the command button.
Make sure that the command button is selected, and then click Properties on the toolbar to open the command button's property sheet.
In the OnClick property box on a form, enter the name of the macro or event procedure that you want to run when the button is clicked, or click the Build button to use the Macro Builder or Code Builder.
On a data access page, you can attach code written in either JScript or Microsoft Visual Basic Scripting Edition (VBScript) to a command button by using the Microsoft Script Editor.