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

M

Mike

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

Douglas J. Steele

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)
 
Top