When date entering in an Access 2003 sheet, I'm proceeding down a column of
numbers, Access always assumes if the numbers between 2 rows are increasing
by one, then the next row's field gets pre-loaded with the next number.

Generally, this is a feature that I do not want.

Is there any way to turn this off? I've looked around the tools options
menu and see nothing to do this.

Unfortunately, there is no option to turn this off.

Microsoft got feedback about this mis-feature, so Access 2007 does not have
this annoyance.

In A2003, the only real solution is to avoid using datasheets. A form in
Continuous view works around it.

--
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.

"Jack Jennings" <(E-Mail Removed)> wrote in message
news:C5757A08-86AF-4D9B-9B6F-(E-Mail Removed)...
> When date entering in an Access 2003 sheet, I'm proceeding down a column
> of
> numbers, Access always assumes if the numbers between 2 rows are
> increasing
> by one, then the next row's field gets pre-loaded with the next number.
>
> Generally, this is a feature that I do not want.
>
> Is there any way to turn this off? I've looked around the tools options
> menu and see nothing to do this.

Thanks for the response Allen. I'll give the continuous form view a try.

"Allen Browne" wrote:

> Unfortunately, there is no option to turn this off.
>
> Microsoft got feedback about this mis-feature, so Access 2007 does not have
> this annoyance.
>
> In A2003, the only real solution is to avoid using datasheets. A form in
> Continuous view works around it.
>
> --
> 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.
>
> "Jack Jennings" <(E-Mail Removed)> wrote in message
> news:C5757A08-86AF-4D9B-9B6F-(E-Mail Removed)...
> > When date entering in an Access 2003 sheet, I'm proceeding down a column
> > of
> > numbers, Access always assumes if the numbers between 2 rows are
> > increasing
> > by one, then the next row's field gets pre-loaded with the next number.
> >
> > Generally, this is a feature that I do not want.
> >
> > Is there any way to turn this off? I've looked around the tools options
> > menu and see nothing to do this.
>
>