Formating numbers: I want '9' to be '009' and '19' to be '019'

How can I do this ? This is the number used in invoice.
Thanks.

re: Formating numbers: I want '9' to be '009' and '19' to be '019'

formatInvoiceNo: Format([InvoiceNo],"000000000")

re: Formating numbers: I want '9' to be '009' and '19' to be '019'

Open the report (form?) in design view, and set the Format property of this
text box to:
000

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"swingingming" <ming.mge@gmail.com> wrote in message
news:1123566670.327279.83700@f14g2000cwb.googlegro ups.com...[color=blue]
> How can I do this ? This is the number used in invoice.
> Thanks.[/color]

re: Formating numbers: I want '9' to be '009' and '19' to be '019'

Thanks. I will stay with your solution. It works fine. Because the
invoice number actually consists of other Texts.