Placing Validation on Forms

[Accession]

Good day everyone,



I have never written codes in access. However, I am familiar with Visual Basic. I created this form in access for a database. I am trying to place validation on the form controls(elements).
Example: Lets say I need a error message to display when a textbox is focused and left empty. I need to make First Name mandatory so if the user click in the text box for first name and leaves it blank and error message is display when they try to leave.

I already have the name field required on the database but can I do this on forms? I tried writing some Visual Basic coded by opening the form and going to design view, then selecting an event but the codes I wrote does not work.

How can I make this work?

Thanks everyone!

AC

[alansidman]

I already have the name field required on the database but can I do this on forms

This means that you have made the field required in the table? If this is the case, is your form bound to your table? If yes, then there is no reason to apply this type of validation as it is already set. If your form is not bound to your table, then that is a different situation and I will have to defer to my peers for that answer.

Alan

[Accession]

This means that you have made the field required in the table? If this is the case, is your form bound to your table? If yes, then there is no reason to apply this type of validation as it is already set. If your form is not bound to your table, then that is a different situation and I will have to defer to my peers for that answer.

Alan

Thanks for responding, I do have the name field required on the database however, that validation does not fire up until the user decides to submit the form. I was simply asking if there is a way to make the form require input when it loses focus, this way the user does not have to complete the entire form before realizing something is missing.


Thanks again.

AC

[stmoong]

You can use the LostFocus event of the control to validate the data entered. If fails, set the focus back to the control so that user can correct the data.