How do you design a database to print running numbers from 1 to 10,000 onto labels? Just like printing customers' names, I want to print lets say numbers from 00001 to 10,000 onto labels, so that I can paste them on in-coming documents. I cannot enter 10,000 records in a table and then use it as a record source in the report to print them on labels, there must be a easy way? Pleas help?

You can do this by having the autonumber primary key field of your main table with the following properties :
New Values : Increment
Format : (00000)

This will save the first record as 00001, second as 00002 and so on. Then, when you want it displayed in a text box just set the format of the text box to 00000, then it will display correctly.

Thanks alot Galphanore. Appreciate it very much.
Benny Kay


You can do this by having the autonumber primary key field of your main table with the following properties :
New Values : Increment
Format : (00000)

This will save the first record as 00001, second as 00002 and so on. Then, when you want it displayed in a text box just set the format of the text box to 00000, then it will display correctly.

Maybe I'm wrong, but I thought this forum was called 'sample databases', where people post examples and don't ask questions unless it's related to an example. :rolleyes: