Results 1 to 6 of 6
  1. #1
    Join Date
    May 2013
    Posts
    32

    Unanswered: Autonumber formating in table

    I have an autonumber in one of my tables for reference number. In the format option in design view I have !"FY13-" so reference numbers count as so:

    FY13-1
    FY13-2
    FY13-3

    I would like the numbers to be displayed as 4 digits long so they display as

    FY13-0001
    FY13-0002
    FY13-0003
    ...
    FY13-0010

    Can this be done at table level?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    how are you setting the -1,-2 & -3
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2011
    Posts
    413

    Autonumbering Format

    Here is an example of what you may be looking for.You should be able to adapt to your needs.
    Last edited by Burrina; 07-30-13 at 20:40.

  4. #4
    Join Date
    Nov 2010
    Posts
    84
    See the following examples:
    Assigning Sequential Number.rar
    Counter.zip
    CounterOffice.rar
    on the following website in my signature

  5. #5
    Join Date
    Oct 2012
    Posts
    56

    Format auto number

    Hi in the format properties on the auto number field in the table

    "FY13-"0000

    first number will show as FY13-0001

    Hope this helps

  6. #6
    Join Date
    May 2013
    Posts
    32
    Quote Originally Posted by Robert(Bob) View Post
    Hi in the format properties on the auto number field in the table

    "FY13-"0000

    first number will show as FY13-0001

    Hope this helps
    Hi,

    Thank you, this worked, simplest solution too!

Posting Permissions

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