Hi experts,

I'm curious to know what can be done in ms access. My boss asked me if it was possible to create an autoname similar to autonumber with the constraints of 8 characters in capitals. This will be used as a customer number on our database. For example the automated customer number will display like this: DERMYTLN on a combo box. Can this be done, if so would you know and explain to me how I can approach this using vba or any other access functionality? Would you have any examples how to do this or know other useful resources I can find to do this?


Thanks for your contributions and knowledge sharing. I am learning everyday.