Leading zeros are shown in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a unique indexed number field. However, in data entry, no
leading zeros are shown. How do I make Access allow leading zeros?
 
Numeric fields do not store leading zeroes. The field must be of Text type
in order to store leading zeroes.
 
Leading zeros belongs to the "Format" Property since numerically 00001 is
the same as 1 and only the value 1 is stored in a numeric Field.

Use the Format Propery of the Control (on the Form) or of the Field (in
DatasheetView of the Table / Query) to show the desiref format including
leading zeros.
 
Back
Top