I am using autonumber field that is set as PK and is used to identify records. Is there a way to give this number with leading zeroes or when you print record it shows leading zeroes, so instead of a record having a “1” for the first record it would look like this “ 00001”. My boss wants it to look pretty.

How to pad character strings (http://support.microsoft.com/default.aspx?scid=kb;en-us;210573&Product=acc)

Regards,
Tim

Even easier: on your report, say you've got a text box holding the primary key field. For the Format property, just type in 00000 instead of choosing one of the available selections. That will make all the numbers five-digit.

Thanks for responding back I am new at this access biz, I am still working on getting the module to work. It works in the immediate window, but I havent been able to apply it to the field yet. In the mean time using the 0000 in the format propeties sections works great.