Display zeros in a table without characters

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

I'm attempting to input a telephone extension number in a
table and cannot for the life of me work out how to
display the zeros at the beginning of the number.
For example: 011
Access always removes the 0 and just displays 11
HELP!!!
 
Sounds like the DataType of your Extension field is Number. Make it Text,
and you can enter the leading zeros.
 
Back
Top