Format on Primary key

T

Teo

Hi!!
I have a question regarding format when you add an item into a colum in a
table in access.
I added an Input Mask that puts a CM- before entering any number. But for
some reason after the row is entered the CM dissapears and only the number
remains.
I want the CM- to stay along with the number as I refernce to this number by
it's whole info, for example CM-233 etc instead of 233.

Thanks much for your help in advance,

Teo
 
T

Teo

And if for example my field type is an auto number?
Can I still use the CVA- infront of the number?
I want it to increment automatically as soon as a record is added.

Regards,
Teo
 
K

KARL DEWEY

You can not do that with Autonumber.

You can have an unbound textbox with record source from a query to pull the
last plus one. Then create an event or macro to put that value in your new
record.
 
Top