AutoFill Feature in Datasheet View

G

Guest

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

Tony Toews

hdfixitup said:
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.
Click to expand...

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
 
G

Guest

I am using Datasheet view of a FORM.

Tony Toews said:
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
Click to expand...
 
J

John Vinson

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.
Click to expand...

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]
 
T

Tony Toews

hdfixitup said:
I am using Datasheet view of a FORM.
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I disable autofill? 3
disable ESC Key delete feature when open table in datasheet view 3
How to Disable??? 1
How to set color of field? 4
Datasheet Column Color 5
Datasheet form 5
Total Row in datasheet view has problems if using ADP / SQL 4
Settinf field sizes in datasheet view 1

Top