How do I setup the Autonumber to be prefixed with text in Access .

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

Guest

I am trying to set up a database of members, and I would like to have the
autonumber prefixed with the following text: COSHM-

Is this possible?
 
If you always want the same prefix, set the field's Format property to
"COSHM-"#

Recognize, though, that all that does is make it look as though the field
has that prefix: what's stored in the database will strictly be the number
(which is as it should be)
 
Back
Top