Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Ephrata, Washington, USA
    Thanked 0 Times in 0 Posts

    4 digit auto number (2003)

    How can I set the format of an autonumber field to be 4 digits with leading zeros (so the first one would be 0001, and if the record number is 777, it would auto number as 0777)?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: 4 digit auto number (2003)

    You can set the Format property of the AutoNumber field to 0000 in the table, and/or in all queries, forms and reports based on the table. If you set the format in the table, all new queries, forms and reports based on the table will automatically inherit the format, but existing ones will not be updated automatically.
    The Format property only changes the way the number is displayed on screen and in printed output. It has no effect on the way the number is stored.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts