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

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?
 
G

Gary Miller

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
________________________
 
K

Keith

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)."
 
G

Gary Miller

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
________________________
 

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

Top