exporting number field with leading zeros

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

Guest

I have a number field in a table that I want to export with leading 0's. For
a number like 100.00, I want to export 0010000. I multiplied the value by
100 to get rid of the decimal and changed the field format property in the
table to 0000000. The data looks fine in the table when I display it in a
form or look directly in the table, however, when I export it as a fixed
length field, the result is 10000. No leading 0's. Got any suggestions?
 
Numbers can have leading zeros displayed, but this doesn't change the
underlying value. 00000123 and 123 are the same values.

If you MUST export 0010000, use a text field.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Or use a calculated field in a query, where the calculated field creates the
desired "leading zero" text string: Then export the query.
 
Back
Top