What is the input mask that you're using? What do the individual characters of the input mask mean?

Input mask for Phone   !\(999") "000\-0000;;_
The 9 in the mask tells Access that it is not required but if you enter something in that position it has to be a number.
The 0 tells Access that, if the whole field is not empty, a number is required in that position.

In this course the input masks are just introduced.  There is a lot more you can do and over the courses you will be given greater detail.  

See also:

TechHelp Video:  Input Mask

You can read more on Microsofts website - HERE

Alex put together a great article in the Glossary that you can look at on Format

Ehem... Scott... I was trying to get her to figure it out on her own. LOL

But thanks. :)

Richard
Yeah I figured.  I was typing, got side tracked,  and after I hit submit yours was there.  OOPS!

One good thing I did answer your question correctly!

LOL

I applaud your effort... but remember, it's always best to let them figure stuff out for themselves... give 'em a nudge, not a push. :)

Yes, indeed, you are correct, sir. :)

Reply to Scott Axton
>>Input mask for Phone   !\(999") "000\-0000;;_
>>The 9 in the mask tells Access that it is not required but if you enter something in that position it has to be a number.
>>The 0 tells Access that, if the whole field is not empty, a number is required in that position.

Thanks Scott, I got it. I have changed the Input Mask by replacing 999 with 000 and that solved the problem.

Try:

\(000") "000\-0000