How to set the length of a field?

[#1]

Hi,

If I have item numbers, that come in in various lengths, say, 3 to 5 characters, but I want to make them all 6 characters long, how do I do that?  I've looked everywhere but can't find any topics pertaining specifically to this, thanks for your help.

[marcus_sommer · Accepted solution]

Try it with num(Field, '000000')

- Marcus

[alexandros17]

If your field name is for example myField then:

=Repeat('0',6-Len(myField )) & myField

let me know

[Anonymous]

yes Marcus is correct  you will get your numbers followed by 0 (zeros)

ex for 10 you will get 000010

[#5]

Perfect! Worked! Thank you!

[alexandros17]

That solution works only with numbers ...