Simple Format Question

[evanesce]

Hi.
I am just into MS Access 2010.
I live in South Korea.
I have a question about the field format.

[Story]
Some old cell phone numbers here have 10 digits like this;
011-123-4567 or 017-123-4567 or 018-123-4567 or 019-123-4567.
Some numbers have 11 digits like this;
011-1234-5678 or 017-1234-5678 or 018-1234-5678
Most of the numbers are 11 digit numbers like this;
010-1234-5678

If I put 10 digit numbers, I want it to be showed like 011-123-4567.
If I put 11 digits, I want it to be like 010-1234-5678 or 011-1234-5678.

How can I do this?



I was thinking about this for an hour.
Still can't find out the answer.
Any help will be greatly appreciated.

Thank you very much again in advance.
Please help!

[aytee111]

Query? Form?

Here is some VBA:

If Len(Me!Text0) = 10 Then Me!Text2 = Format(Me!Text0, "000-000-0000")

[Robeen]

Where would you be entering these numbers?
Would it be in a Form?

Didn't see aytee111's post - sorry.