Show number as 001 (incremental)

[kwirky]

Hi,
I am trying to produce box labels which have a string that needs to end in numbers like 001, 002, 003 etc to a maximum which is equal to the total number of boxes.
I tried using record number however this displays as 1, 2, 3, 4 etc.
How can I get the record number to format the way I need?
For example I have an order with 16 boxes; the order number will be something like ABC606806 so I will need the boxes to be
ABC606806001
ABC606806002
ABC606806003
all the way to
ABC606806015
ABC606806016

The number of boxes per order will vary from 1 to as many as we need.
I would like to calculate to 999 (so the label would be ABC606806999).

We are using CR2008

 

[IanWaterman]

Use totext()

Totext({yournumber field or formula}, "000")

You can also concatenate this to your order number

@OrderNum
{ordernumfield}&Totext({yournumber field or formula}, "000")

Ian

 

[kwirky]

Perfection. Thank you