Increment a number in a text field

[Gary]

I'm having problems getting a text field to automatically
increment, exp. when you add a record to a form, it
should automatically give a new id number, such as

Book-001, Book-002, etc. There is a knowledge base
article on this for Access 2000, but I'm using Access
2002 and cannot get that one to work, as it keeps giving
me an error, i.e., "not a defined data type". If anyone
has any ideas, I would really appreciate it. I've tried
searching the knowledge base for an hour, to no avail.

thanks

[Jim/Chris]

I am not sure I understand. Only number fields can
increment, not test fields. If it is a number field is
the format in the table set to "autonumber"

Jim/Chris

>-----Original Message-----
>I'm having problems getting a text field to automatically
>increment, exp. when you add a record to a form, it
>should automatically give a new id number, such as
>
>Book-001, Book-002, etc. There is a knowledge base
>article on this for Access 2000, but I'm using Access
>2002 and cannot get that one to work, as it keeps giving
>me an error, i.e., "not a defined data type". If anyone
>has any ideas, I would really appreciate it. I've tried
>searching the knowledge base for an hour, to no avail.
>
>thanks
>
>
>.
>

[Gary]

Ron;
Thanks for the help. I'll try it. This is similar to
what a Microsoft Knowledge base suggested for 2000, but a
bit here and there new.

I'm not sure why its poor design. On another database,
which uses this on Access 2000 (where it works fine), we
have >15,000 items listed. There, instead of "Book-001",
we use the year, i.e., "99-001"...."00-001"..... "03-
001".....where the 99, 00, etc. are text since we (and
our support group)couldn't figure out how to do it
differently and still have unique coding for each sample.

I'm trying to convert over all of these to 2002 and with
2003 coming, well....I'm not a programmer, but it seems
to work. The new one that I need is in 2002, thus
the "Book-001"....