input masks

  • Thread starter Thread starter Bhavin
  • Start date Start date
B

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?
 
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
 
Back
Top