Errors in Autonumber ID field

[M Skabialka]

I was given an Access II database that I upgraded to Access 2003, then
Access 2007.
I created a simple form based on the main table but when I try to filter any
field on the form (e.g. sort a-z, or Text Filter - begins with AR) there is
an error message that says "The value you entered isn't valid for the field
'ID'. For example, you may have entered text in a numeric field or a number
that is greater than the FieldSize setting permits.
From the form I can see the highest ID value is 356 in the autonumber field.
In design view that table shows an autonumber ID field, but in datasheet
mode the ID field does not show up - the field is hidden somehow - so I
can't see what might be wrong.
What is hidning the field, and what might be causing this error?
Mich

 

[John W. Vinson]

I was given an Access II database that I upgraded to Access 2003, then
Access 2007.
I created a simple form based on the main table but when I try to filter any
field on the form (e.g. sort a-z, or Text Filter - begins with AR) there is
an error message that says "The value you entered isn't valid for the field
'ID'. For example, you may have entered text in a numeric field or a number
that is greater than the FieldSize setting permits.
From the form I can see the highest ID value is 356 in the autonumber field.
In design view that table shows an autonumber ID field, but in datasheet
mode the ID field does not show up - the field is hidden somehow - so I
can't see what might be wrong.
What is hidning the field, and what might be causing this error?
Mich

It's very likely that you have a Lookup Field defined. Open the table in
design view and view this field's properties (in the lower left); select the
lookup tab, and see if it says Combo Box. If so change it to Textbox.

This may not be the issue but it's the first thing I'd check.

 

[M Skabialka]

No lookup fields. And no ID field in datasheet view either. I have
decompiled, and compact/repaired also to no avail.

 

[M Skabialka]

I recreated the table design (copied the data) and form from scratch and now
do not have the error.

 

[M Skabialka]

Alos, I found the ID field width in the table was 0, so is now visible once
I enlarged it.