Fill series in datasheet

[Jan]

A particular Access behaviour was brought to my attention: when you enter data in a numeric field and you go from one record to the next, always entering data in the same field, Access will fill the series 1,2 with 3,4,.. or 2,4 with 6 and so on.
example

FIeld1 Field2(numeric)
ABC
DEF
GHI

then fill field2 with 1, next 2, Access proposes 3 for the third record

Is is possible to turn this autofill behaviour off ?

 

[Allen Browne]

Hi Jan.

Agreed that the behaviour is very annoying, and completely inappropriate for
a database.

Unfortunately, MS has not provided a way to turn this off.

From memory, you can work around it by opening a form in continuous view
instead of using data sheets.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

A particular Access behaviour was brought to my attention: when you enter

data in a numeric field and you go from one record to the next, always
entering data in the same field, Access will fill the series 1,2 with 3,4,..
or 2,4 with 6 and so on.

 

[Jeff Boyce]

Jan

To echo Allen's sentiment, you probably need to be working in forms anyway.
They have a very rich event set.

Good luck

Jeff Boyce
<Access MVP>