G Guest Sep 7, 2004 #1 How do I show leading zeros in access tables? eg "0-004-3" shows as " - 4-3" using the mask "0-000-0"
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 Sep 7, 2004 #2 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.
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.
