Validate text field

[redsand]

I am having difficulties validating a text field. I want to force the user to enter a phone number.
I am setting the validation to IS NOT NULL in the table. I know I am not doing something correct. Can anyone help. Thanks

 

[johncb]

You could put some code onto the ON EXIT event of your text field. You could then test the field for your required contents and display an error message using a message box if it is incorrect.

John

 

[GeekGirlau]

You can also run a check in the BeforeUpdate event for the form.