adding zeros before a number in a numeric field

[Guest_imported]

I am trying to create a database to handle the sendng of packages. these are split into accounts (many different users and companies), consignements (each account has many consignements) and packages (etc.). For the account table i want to have fields such as telephone number, account number, etc.

However, if these are placed as numeric fields, a telephone number will, for example, be displayed as 1495 673731 instead of 01495... I think i need something like an input mask but can sum1 please help???

P.S placing it as a text field is not satisfactory as this has validation problems related to it.

 

[Zelandakh]

There is a telephone number input mask wizard which should help you.

Start off with (99999)000009 as the input mask and see if that gives you what you want.