How to validate info on a form before submitting?

Please excuse me as I have very little, actually no exp. with Microsoft Access.  This seems like it would be an easy question for you experts to answer, but a EXTREMELY difficult one for me.  I thought I would ask first, instead of wasting an entire day trying to figure it out.

Here it goes:

2 part question.

1.  In a form, I am asking a user for their email address.  I am also asking them to reenter it in another field to make sure they entered it right.  First, how do I make sure they entered a valid email address?  Ex:  someone@company.com  

And then, how do I have the first one compare to second to make sure they match?


2.  I have many fields on my form as well as a submit button that runs a macro.  I would like to make sure that something is entered into each field or a message box will pop up with a message that says something like, "Please enter your last name" or "Opps, you forgot to enter your phone number" or "Email address is not valid".

To wrap it up, the form wouldn't be able to be submitted until all fields have been filled out.

Hopefully this will help.  My form contains the following fields:

firstName
lastName
address1
leadcity
state
zip
email
reenterEmail
carsHousehold
driversHousehold
ownHome (drop down box, with a yes/no option)
insuredBy

Any assistance would be greatly appreciated.  Thank you so much in advance.Start Free Trial