I am entering data intot eh Access spreadsheet. Any time two columns begin a
series, Access auto fills the next number. If col1=2 and col2=3 it puts a
"4" into col3. Same if first col=2 and next col=4 it pusta "6" in the third
col. Often, they are values that are not allowed and i keep getting error
messages. Is there any way to turn off this automatic filling of cells?

Access does not use spreadsheets. Excel uses spreadsheets. Access uses
tables, queries, forms.

When you are using a table to input data, it will sometimes exhibit this
behavior, which is an unfortunate coding decision associated with Microsoft
Office. You should not be using a table or query to input data. You should
be using forms to input data, and then you will not see this happening.

"Psychlogic" wrote:

> I am entering data intot eh Access spreadsheet. Any time two columns begin a
> series, Access auto fills the next number. If col1=2 and col2=3 it puts a
> "4" into col3. Same if first col=2 and next col=4 it pusta "6" in the third
> col. Often, they are values that are not allowed and i keep getting error
> messages. Is there any way to turn off this automatic filling of cells?