Help with Input mask for telephone numbers

[Nobby]

A new user to Access, so be gentle with what is obviously a simple question.

Trying to create a form that will enter employees details into a database.

I wanted the form to show telephone number as:
(01732)616161
I have used the following mask:"(0"0000") "000000

However, if the 2nd digit is greater than 1, eg (02063) ....., the entry is rejected as not being valid for this field.

Second part of the question, is there a way of pasting a format from an form box to another, as you can do in Excel?

Thanks

 

[manners]

Try using #'s instead of 0's.

eg-

(0"####") "######"

 

[Nobby]

Unfortunately, your suggestion didn't work. Same error occurring.
It will accept any number in any other position but always rejects an entry if the phone number starts higher than (01...) eg(02....?

 

[Rich]

Firstly it looks as if the first part of the number is an area code, in which case you'd be better off storing that in a seperate table. If you type masks in the help file it will give you a list of various characters you can use instead of the default ones the wizard creates.
HTH