AutoNumber field does not contain "(AutoNumber)" when adding a record

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

When creating a new record in a form, the AutoNumber field
populates with a new number, not the words "(AutoNumber),"
and the NEXT RECORD navigation button does not gray out,
allowing anyone to continually add blank records to the
table.

Any ideas about what might be causing this?
 
Keith,

This sounds like very normal behaviour if you have not set
any fields to be 'required' to be filled in in your table
design. You would probably want to flag at least a few for
this. As your autonumer will increment, it is now a new
record even though they didn't fill any of the other fields
in.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
That's the strange part. I have a required field (I also
have one field with a default value), but the next record
automatically places the auto number, not the words "(Auto
Number)."
 
Keith,

That is what an autonumber field is supposed to do. It will
say '(AutoNumber)' until something is entered into the
record and then it will change from that to the automatic
number that an autonumber field is supposed to generate.
They are designed to generate a unique new number for each
record.

Do you want it to store the value 'Autonumber'?

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top