Autonumber prefix

[Matt Brown]

Is it possible to add a prefix to the autonumnber.
I have tried but failed.
I would like to be able to place the following prefix:

CN

To a autonumber field.
Any help appreciated
Matt

 

[The_Doc_Man]

The issue is, of course, whether you want the autonumber to contain this field or merely to display CN as a prefix when shown on forms or reports - or, for that matter, in datasheet view.

I will say right off that I personally see no advantage to storing a constant "CN" in a number. Two bytes that you could predict in your sleep. Why track 'em?

I respectfully suggest that you look up the formatting topics for ways to include constant text with a displayed field. Specifically, the FORMAT function for queries, forms, and reports, and the FORMAT property for fielddefs within a tabledef.

 

[Matt Brown]

Thanks
Matt