prefix for number

[basilyos]

Hello Guys

every video i enter to my database will get a unique ID

for example

1 Rain Man
99 Cyborg

what i want to do is when i save the record to get a message box contains the id with prefix

the prefix should be V000000

so when the id is 1 the message box should give me V000001
if the id is 99 the message box should give me V000099

any help?

 

[CJ_London]

usze something like "V" & format(ID,"000000")