View Single Post
  #2  
Old July 30th, 2004, 02:47 AM
Laurie Eaton
external usenet poster
 
Posts: n/a
Default negative autonumber

Hi aa,

It a long shot - but try expanding the width of that column in your view, since the presentation of numbers changes when the width is too small and the '2' may be coming from 1E+02 when you have more than 100 entries. You mention the number is negative which does not align with this theory, but I suggest check it anyway.

Regards - laurie Eaton
"aa" wrote:

I have an ID field set to autonumber.
The table has a primary key combined of three other fields, ID is not one of
them
The table is being populated via a form where the ID filed is filled
automatically.

I have been adding records for several days and everything was OK untill
today I noticed, that all the records I added today have been assigned the
same negative ID -02
And even one of the records I enetered time ago, changed its ID to -2

What is going on and how do I fix it?

a