leading zeroes

[stefangs]

i have an inventory system that deals with strictly 8-digit numbers. so i want to be able to have leading zeroes to display something like 00002367.

i can enter that into a number or text field, but if the number is changed via a script, FM always truncates the leading zeroes which results in a correct number, but incorrect display. is there a nifty text function perhaps, so that the output will always have 8 digits?

[slstrother]

You can use the following calc to convert the data in a number field to text with leading zeros.

Left("00000000",Length("00000000")-Length(NumberField))&NumToText(NumberField)

[RussBaker]

Or... Right("00000000" & NumToText (Number),8)

[Vaughan]

Make sure the field is text, not number.