How do I show leading zeros in access tables (eg "0-004-3" shows .

C

Craig Davis

How do I show leading zeros in access tables?
eg "0-004-3" shows as " - 4-3" using the mask "0-000-0"
 
R

Reggie

Craig, It's because your data type for the field in the table is a number. Change it to text and
the leading zero's will stick.
 
Top