Fill series in datasheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jan - 20 Jan 2004 09:51 GMT

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 ?

Reply to this Message

Allen Browne - 20 Jan 2004 10:56 GMT

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.

Signature

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.

> 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
>
[quoted text clipped - 6 lines]
>
> Is is possible to turn this autofill behaviour off ?

Reply to this Message

Jeff Boyce - 20 Jan 2004 12:58 GMT

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

Reply to this Message