Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    autonumber (2002)

    How can I get autonumber to generate four digit numbers 0001 instead of 1 0002 instead of 2 etc.

    Thanks

    Paul

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: autonumber (2002)

    You can set the Format property of the AutoNumber field to 0000. The underlying values will still be 1, 2, 3 etc., but they will be displayed as 0001, 0002, 0003 etc.
    If you really need the values to be 0001 etc., you can't use an AutoNumber field, or any number field. You should use a text field instead, and use code behind a form to populate it.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: autonumber (2002)

    Ok- adding 0000 to format in the autonumber field makes the autonumber appear as 4 digits in the table ex. 0012.
    How do I get that autonumber to appear as a 4 digit number on a form or report? I am not going to do any calculations etc with the autonumbers. I just want it to appear as 0012 and not 12.

    Do I have to avoid using autonumber for this?

    Thanks

    Paul

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: autonumber (2002)

    Set the Format property of the text box bound to the AutoNumber field to 0000.

    You can use an AutoNumber field, just keep in mind that if users delete records, or if they start to create a record then abandon it, there will be gaps in the sequence.

Posting Permissions

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