Conversion of a number to an exported text field with front loaded

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

Guest

I have number field with 123. I need to export 0000123. The format property
of 0000000, takes care of the table showing it as 0000123 if I convert the
number field to a text. The exporting process (fixed length) remembers the
significant figures and as text output it is "123 ", not "0000123".
Any suggestions?
 
Use the Format function (in a query), rather than the Format property. The
Format function will actually convert the number to a string.
 
Back
Top