Format on Primary key

[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

 

[Guest]

Instead of Input Mask use the default value.

 

[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

 

[Guest]

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.