negative autonumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top