I create a table called tblReceipt and i want to make the field called "ReceiptID" to auto increment each time i enter a new record (e.g A0001, A0002, A0003 and so on). is it possible?

I needed a similar thing a few weeks back. I set the field as autonumber (1, 2, 3...) , and then anytime I sent it to either a form or report, I formatted it as A###. Let me know if you would like me to post the code to do this, or anything...

HTH

Mike

Mike
EchoVue.com

can you post me the code for me .. thank you very much