Numeric Field Auto-Fill-in

[Dave Stone]

I find with a table in datasheet view, if a Number field is blank, and I
fill it in for a series of rows (more than 2) with values incrementing by 1
or 2 (only), then Access 'helpfully' fills in the field in the 3rd and
subsequent rows in turn, incrementing by the 'appropriate' amount. So if
Product# is filled in in row 1 as 123, down-arrow to Product# in row 2 and
type 125, down-arrow to Product# in row 3, Access has filled in 127. Is
there any way of preventing this other than starting at the bottom of the
column and using up-arrow?

Dave

--
************************************************** **********************
Dave Stone e-mail: D.*****@ed.ac.uk
Computing Services Telephone: [phone]
University of Edinburgh Internal ext: 503314
Main Library, George Square FAX: [phone]
Edinburgh EH8 9LJ
************************************************** **********************

[Allen Browne]

Hi Dave.

Agreed that this behavior is completely inappropriate in a database.
Unfortunately, there is no built-in way to turn this nonsense off.

The simplest workaround is to use a form in continuous view in place 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.

"Dave Stone" <D.*****@ed.ac.uk> wrote in message
news:cp**********@scotsman.ed.ac.uk...

I find with a table in datasheet view, if a Number field is blank, and I
fill it in for a series of rows (more than 2) with values incrementing by 1
or 2 (only), then Access 'helpfully' fills in the field in the 3rd and
subsequent rows in turn, incrementing by the 'appropriate' amount. So if
Product# is filled in in row 1 as 123, down-arrow to Product# in row 2 and
type 125, down-arrow to Product# in row 3, Access has filled in 127. Is
there any way of preventing this other than starting at the bottom of the
column and using up-arrow?