Letters before an auto_increment

  • Thread starter Thread starter Guest
  • Start date Start date
Is there a way to place letters infront of an auto_increment? like KK1000

If it's always the same letters just use the Format property of the
field to display it.

But note that Autonumbers will *always* have gaps and can become
random; most developers avoid displaying them in any way that users
will even see, much less need to note.

If the letters might differ from record to record, then it's much
better to store them in TWO fields, a Text field and a Long Integer
field, and concatenate them for display.
 
Back
Top