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

N

NewHeartMan

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?
 
D

Douglas J. Steele

Use the Format function (in a query), rather than the Format property. The
Format function will actually convert the number to a string.
 
Top