phone number input mask

[rvd48]

im consistanly getting error boxes when i try to type in a phone number such as e.g. : 0113 2346410

the input mask for the phone number field is: 9000#\ 0000000

could somebody tell me on what i need to change in the input mask code?

 

[ghudson]

You were close. The zeros are required and the nines are optional so you should only use zero's in your mask. This will also not store the space in the table for that field.

0000\ 0000000;;_

 

[rvd48]

thanks for the help ghudson

i have a slight problem, when i type in e.g. 0113 2402425, the 0 doesnt appear. it just displays 113 2402425.

im puzzled by this. can you help me?

 

[ghudson]

You will have to format the field within the table design as TEXT if you want the preceding zeros to stick.

 

[BarryMK]

As another UK user I just delete all input masks for phone numbers as UK dialling codes don't hold to a set number of digits. Then you can simply type your numbers in as normal.

 

[Rich]

The area codes should be stored in a separate look up table too

 

[BarryMK]

The area codes should be stored in a separate look up table too

Blimey Rich that might be best practice, but it would definitely be over egging the pudding as far as my simple databases are concerned. How's the weather down West it's grotty here?

 

[Rich]

Glorious sunshine, as always