>>>Is there anyway at all to get a numeric field to display 3 zeros?
>>
>>Not that I know, but one could store 3 zeros in a string. You could have 3 numeric fields and use features embedded in Textbox to make the 3 zeros
appear a single field.
>>
>Hi Terry:
>
>Thank you for your reponse. I have a situation where I have classified a field as a numeric field, but now have a situation wherein I have to use 000 in that field. For now, I am testing to see if the display in a text fille will be 000 for any field that has a 0 in it.
Display transform(Field, "@L 999") instead. It will give you leading zeros. But this also means you'll get 001 for 1, 020 for 20 etc. If you need it for zeros only, then transform(Field, iif(field=0, "@L ","")+"999").