autofill

[LCalaway]

Happy 4th, all

How do you turn off the following type of autofill:

Example: I have created a table with four text fields. When entering
numeric data in these fields, by the third field, a number will
automatically fill the field. It will be based on the numeric progression
of the first two numbers - so

If field 1 = 1 and field 2 = 3, the third field will automatically enter 5
and field 4 will be 7.

The same thing happens if numbers are entered in contiguous records -- if
record 1, field 1 = 2, and record 2, field 1 = 3, the table will
automatically generate a 4 in record 3, field 1.

I experimented with AutoCorrect, but that doesn't appear to be the feature
controlling this.

(1) What is this called?
(2) How do you control it?

Thank you.
LCalaway

[Wayne Morgan]

We would love to turn that off. I haven't heard of a way to do it though.

--
Wayne Morgan
MS Access MVP

"LCalaway" <re******@gte.n et> wrote in message
news:nRgye.3241 $3Y3.1576@trndd c09...

Happy 4th, all

How do you turn off the following type of autofill:

Example: I have created a table with four text fields. When entering
numeric data in these fields, by the third field, a number will
automatically fill the field. It will be based on the numeric progression
of the first two numbers - so

If field 1 = 1 and field 2 = 3, the third field will automatically enter 5
and field 4 will be 7.

The same thing happens if numbers are entered in contiguous records -- if
record 1, field 1 = 2, and record 2, field 1 = 3, the table will
automatically generate a 4 in record 3, field 1.

I experimented with AutoCorrect, but that doesn't appear to be the feature
controlling this.

(1) What is this called?
(2) How do you control it?

Thank you.
LCalaway

[LCalaway]

Thanks for the reply.

I found Article 271607 of June 28, 2004 issued by Microsoft that sez that
this thing came into being with Access 2000 and that it cannot be disabled.
I am looking for a workaround if anyone can think of one.

My attempt for the field-to-field problem was to insert a field that I
wouldn't use and then in the table user view, hide the field. Another idea
was to make that hidden field a currency field. In both of these instances,
I'm hoping that because the hidden field is bypassed, the increment feature
will fail. This seems so silly, I think I want to cry.

LCalaway
"Wayne Morgan" <co************ *************** @hotmail.com> wrote in message
news:3k******** *********@newss vr30.news.prodi gy.com...

We would love to turn that off. I haven't heard of a way to do it though.

--
Wayne Morgan
MS Access MVP

"LCalaway" <re******@gte.n et> wrote in message
news:nRgye.3241 $3Y3.1576@trndd c09...

Happy 4th, all

How do you turn off the following type of autofill:

Example: I have created a table with four text fields. When entering
numeric data in these fields, by the third field, a number will
automatically fill the field. It will be based on the numeric
progression of the first two numbers - so

If field 1 = 1 and field 2 = 3, the third field will automatically enter
5 and field 4 will be 7.

The same thing happens if numbers are entered in contiguous records -- if
record 1, field 1 = 2, and record 2, field 1 = 3, the table will
automatically generate a 4 in record 3, field 1.

I experimented with AutoCorrect, but that doesn't appear to be the
feature controlling this.

(1) What is this called?
(2) How do you control it?

Thank you.
LCalaway