Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Don't want automatic sequential numbering in Access 2003

Discussion in 'Information Technology' started by angela.quinn@gmail.com, Jul 28, 2006.

  1. angela.quinn@gmail.com

    angela.quinn@gmail.com
    Expand Collapse
    Guest

    I noticed that in Access 2003 there is a feature that automatically
    populates the next field in a series of numbers with the next number in
    the sequence. In case I didn't say that right.. if you enter a "0" in
    one field and a "1" in the next field, when you hit enter, the next
    field automatically populates with a "2", assuming you want the
    shortcut for a sequential numbering. I feel like this introduces a
    potential source of data entry error, especially since we often use 0
    and 1 for "no" and "yes" respectively and may skip fields. I don't
    want to always use a default of "0" because I sometimes want the fields
    left blank if nothing is answered. Anyway, I really don't like this
    feature and I was wondering if there is a way to turn it off somehow.
    Or get around it...Thanks in advance for any help...
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---Don't Breathe Theatre, Movies & Cinema Sep 19, 2016
    One Step Forward, One Step Backward , You Don't End Up Anywhere Hard Talk Aug 6, 2016
    It Seems Like Almost Everybody Out There Hates Me For Something But I Don't Know What It Is Hard Talk Jun 2, 2016
    You don't want to kill me Harry Blogs Oct 17, 2015
    Windows 10-don't Click That Tab! Information Technology Aug 10, 2015

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Microsoft has heard this as a pain point, and so Access 2007 will not have
    this annoying behavior.

    There is no way to turn it off in a datasheet in A2003.
    You can avoid it if you use a continuous form instead of a datasheet.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    <angela.quinn@gmail.com> wrote in message
    news:1150819424.166337.293690@c74g2000cwc.googlegroups.com...
    >I noticed that in Access 2003 there is a feature that automatically
    > populates the next field in a series of numbers with the next number in
    > the sequence. In case I didn't say that right.. if you enter a "0" in
    > one field and a "1" in the next field, when you hit enter, the next
    > field automatically populates with a "2", assuming you want the
    > shortcut for a sequential numbering. I feel like this introduces a
    > potential source of data entry error, especially since we often use 0
    > and 1 for "no" and "yes" respectively and may skip fields. I don't
    > want to always use a default of "0" because I sometimes want the fields
    > left blank if nothing is answered. Anyway, I really don't like this
    > feature and I was wondering if there is a way to turn it off somehow.
    > Or get around it...Thanks in advance for any help...
     
  4. angela.quinn@gmail.com

    angela.quinn@gmail.com
    Expand Collapse
    Guest

    Well, at least I know I'm not missing an obvious fix. I was using a
    table directly for data entry, but maybe I can create a continuous form
    and just do it that way. I'll try it. Thanks!

    Allen Browne wrote:
    > Microsoft has heard this as a pain point, and so Access 2007 will not have
    > this annoying behavior.
    >
    > There is no way to turn it off in a datasheet in A2003.
    > You can avoid it if you use a continuous form instead of a datasheet.
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > <angela.quinn@gmail.com> wrote in message
    > news:1150819424.166337.293690@c74g2000cwc.googlegroups.com...
    > >I noticed that in Access 2003 there is a feature that automatically
    > > populates the next field in a series of numbers with the next number in
    > > the sequence. In case I didn't say that right.. if you enter a "0" in
    > > one field and a "1" in the next field, when you hit enter, the next
    > > field automatically populates with a "2", assuming you want the
    > > shortcut for a sequential numbering. I feel like this introduces a
    > > potential source of data entry error, especially since we often use 0
    > > and 1 for "no" and "yes" respectively and may skip fields. I don't
    > > want to always use a default of "0" because I sometimes want the fields
    > > left blank if nothing is answered. Anyway, I really don't like this
    > > feature and I was wondering if there is a way to turn it off somehow.
    > > Or get around it...Thanks in advance for any help...
     

Share This Page