Access table entry quirks

  • Thread starter Thread starter Gary J. Dikkema
  • Start date Start date
G

Gary J. Dikkema

I have an Access application where I scan information into a single column
table and at times the information that is scanned in is almost sequential
in content and I see Access creating the to be scanned row with the
information from the prior row plus 1...

How do I prevent this?

For example,

001005 <<<--- row 1
001006 <<<--- row 2

Access would have row three containing 1006.

When we scan in the next item sometimes this value gets overlayed and
sometimes it doesn't...

How do I prevent Access from doing this? The field is a text 6 field.

It almost reminds me of Excel where if you enter numbers down a column if
they are sequential Excel will put the next sequential value in the next
row.

TIA.

Gary D
 
This really annoying behavior is Access trying to be too helpful (again.)

AFAIK, you cannot turn that off in Datasheet view. However, if you create a
form in Continuous view, it can look similar and will not have this
behavior.
 

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

Data in Fields Changing Automatically 1
Turning a 3 column flat file into a "3D" Table 2
Sequential or Auto numbering in table 3
Stop Access auto-suggesting increments during data entry (datashee 2
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Highlight/Select Quirk - DRIVING ME NUTS 2
Access #Error & Excel Pivot 0
How can I import an unstandard Excel worksheet into Access 2007? 3

Back
Top