How To Auto-Increment A Field In MS Access 2007?

  • Thread starter Thread starter Mr Access
  • Start date Start date
M

Mr Access

I'm accustomed to Access 2003 where you can enter a number in field 1 - say
100, then below that enter 110 and just arrow down from that point as the
program automatically detected you are incrementing and were sequencing by
ten - it would automatically enter 120 in the next field and 130 in the next
and so on until you stop arrowing down... Access 2007 does not have this
feature called out in any of it's help screens or online searches. Is this
feature lost in 2007?
 
Are you sure that was in Access? I've only seen it in Excel. Too bad I
missed it, if it used to be available.
 
On Wed, 25 Feb 2009 12:38:01 -0800, Mr Access <Mr
I'm accustomed to Access 2003 where you can enter a number in field 1 - say
100, then below that enter 110 and just arrow down from that point as the
program automatically detected you are incrementing and were sequencing by
ten - it would automatically enter 120 in the next field and 130 in the next
and so on until you stop arrowing down... Access 2007 does not have this
feature called out in any of it's help screens or online searches. Is this
feature lost in 2007?
Click to expand...

They finally got rid of this misfeature... ooops, sorry, you liked it <g>

Seriously, in a properly normalized database you'ld never need this; and you
should not be working in table datasheets in any case. You can write code in a
Form to autoincrement a field if you need that capability.
 
Back
Top