input masks

[Bhavin]

The input mask i have used for a telephone numnber is as
follows:

999\ 0000\ 0009;0;" "

This however does no allow the first zero to be stored
when entered e.g. 020 **** ****

How can i make Access record the first zero in the 020?

 

[Gerald Stanley]

I would guess that the data type you are using on the table
to store this information is a Number. If you wish to
store it in its formatted state with the leading 0, try
using the Text Data Type.

Hope That Helps
Gerald Stanley MCSD