Leading Zeros

[Lawrence E. Oliver]

I am running Access 2003 and importing data from Excel 2003.

One field has a six digit film number and some of these numbers have leading
zeros. I can not get Access to maintain the leading zeros in the field or to
show them on a report.

How do I get Access to show these leading zeros.

Larry

 

[Rick Brandt]

I am running Access 2003 and importing data from Excel 2003.

One field has a six digit film number and some of these numbers have leading
zeros. I can not get Access to maintain the leading zeros in the field or to
show them on a report.

How do I get Access to show these leading zeros.

Either use a Text DataType instead of Number or set the Format property on your
forms and reports to "00000" (using the number of zeros appropriate to your
purpose).

If you want to simultaneously see records like 0123 and 45 then you have to use
a Text DataType. A Format property will want to force the same length for all
records padding as many zeros as it takes to achieve that.

 

[Lawrence E. Oliver]

Thanks -

Larry

Either use a Text DataType instead of Number or set the Format property on
your forms and reports to "00000" (using the number of zeros appropriate
to your purpose).

If you want to simultaneously see records like 0123 and 45 then you have
to use a Text DataType. A Format property will want to force the same
length for all records padding as many zeros as it takes to achieve that.