I am new to Access 2003 and noticed as I type in a number in a field in
Datasheet View and move down to the next record, Access is recognizing a
sequence and fills in the field automatically. I type 1,2 and Access fills
with a 3. Can really get me in trouble if I don't watch every move. HOW DO
I SUPPRESS THIS FEATURE? Anyone.

hdfixitup <(E-Mail Removed)> wrote:

>I am new to Access 2003 and noticed as I type in a number in a field in
>Datasheet View and move down to the next record, Access is recognizing a
>sequence and fills in the field automatically. I type 1,2 and Access fills
>with a 3. Can really get me in trouble if I don't watch every move. HOW DO
>I SUPPRESS THIS FEATURE? Anyone.

You can't suppress this feature by using the datasheet view in a
table.

We suggest using a form instead.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

I am using Datasheet view of a FORM.

"Tony Toews" wrote:

> hdfixitup <(E-Mail Removed)> wrote:
>
> >I am new to Access 2003 and noticed as I type in a number in a field in
> >Datasheet View and move down to the next record, Access is recognizing a
> >sequence and fills in the field automatically. I type 1,2 and Access fills
> >with a 3. Can really get me in trouble if I don't watch every move. HOW DO
> >I SUPPRESS THIS FEATURE? Anyone.
>
> You can't suppress this feature by using the datasheet view in a
> table.
>
> We suggest using a form instead.
>
> Tony
> --
> Tony Toews, Microsoft Access MVP
> Please respond only in the newsgroups so that others can
> read the entire thread of messages.
> Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
>

On Fri, 29 Dec 2006 16:24:00 -0800, hdfixitup
<(E-Mail Removed)> wrote:

>I am new to Access 2003 and noticed as I type in a number in a field in
>Datasheet View and move down to the next record, Access is recognizing a
>sequence and fills in the field automatically. I type 1,2 and Access fills
>with a 3. Can really get me in trouble if I don't watch every move. HOW DO
>I SUPPRESS THIS FEATURE? Anyone.

This misfeature has been in Access since A2000, over the repeated and
vehement objections of a lot of folks. You can't turn it off in
datasheets.

Consider using a Continuous Form. That's the only solution I know!

John W. Vinson[MVP]

hdfixitup <(E-Mail Removed)> wrote:

>I am using Datasheet view of a FORM.

Same thing. Don't use the datasheet view of a form. Use the Form
View instead.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

I *think* this misfeature has finally been removed in 2007.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conrad...essjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

"John Vinson" wrote in message:
news:(E-Mail Removed)...

> This misfeature has been in Access since A2000, over the repeated and
> vehement objections of a lot of folks. You can't turn it off in
> datasheets.
>
> Consider using a Continuous Form. That's the only solution I know!