Datasheet AutoInsert

[kermit]

I have a form that is set to datasheet and the users come in and insert records, there are about 10-12 fields that they enter. But when they hit about the third or fourth record the form starts to auto-insert data. So the user enters a "1" into the first field and if they press tab to the next field it auto populates a "2", and then a "3" into the third field, and so on and so forth down the line.

Is there any way to stop this auto-Populate? Is this just a setting in Access somewhere that i can turn off? Or is this a setting for the datasheet?

Hopefully i have explained this well enough-
Thanks for your help-

-Frustrated Frog

 

[Elana]

Here's the answer to your question -

MS Knowledge Base Article 271607

HTH
E

 

[kermit]

autofill

thanks for the information. but i have only one more question.

MS says it cannot be dissabled. Is this true? is there a way around it? i cant believe that someone would design it so that it cannot be dissabled...

-frog

 

[Elana]

You can't disable it if you are in datasheet view, but if you change your format to continuous forms or single form, it doesn't happen...at least it didn't when I tested it.

hth
E