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.
AutoNO Leading 000
- Thread starter dgoold
- Start date
dcx693
Registered User.
- Local time
- Today, 04:33
- Joined
- Apr 30, 2003
- Messages
- 3,263
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.
It worked
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.
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.
Last edited:
Similar threads
