How do I make "2-3453-99" appear "00002-3453-99" in access?

[Guest]

I am trying to have a number appear on a report in the following format:
00000-0000-00. The number is stored in the database as an integer: 2123412.
I just need to have 0 attached to the front of the number, so it will appear
like: 00002-1234-12.

 

[AnandaSim]

I am trying to have a number appear on a report in the following format:
00000-0000-00. The number is stored in the database as an integer: 2123412.
I just need to have 0 attached to the front of the number, so it will appear
like: 00002-1234-12.

Use the Format function or the Format property of the textbox. Read up
on format placeholders:

http://office.microsoft.com/client/helppreview.aspx?AssetID=HV100820021033&ns=MSACCESS.DEV&lcid=1033