Hi to everyone one out there.
I have a form with the following fields, clientid (autonumber), category(combo box with custom lookup values). Now i want to display the customerid as category+clientid, ie if the category is A1 and the client id is 1, I want to display as A1-00001. I've set the autonumber field's format property to "0000" as well.

Have you read this link yet?

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

Respected RuralGuy, link you had provided doesn't seem to resemble my problem. Let me clearly explain my scenario. I have three fields in my table namely Client_ID (AutoNumber), Category(Text) & Customer_ID(text) I 've formatted the client_id to prefix leading 0's eg 000001, the category field is something like A1. Now I want to customer_id to be as Category&Client_ID ie something like A1-000001. Kindly advice me how to display this in form, I tried Customer_ID = [Category]&"-"&[Client_ID], but it displays as A1-1 instead of A1-000001.
Thanks in advance.

Try:
Customer_ID = [Category] & "-" & Format([Client_ID],"000000")

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"

Respected RuralGuy,

It finally works. Thanks for the reply.

Excellent! Glad to hear you got it sorted.

__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07
If your issue is resolved...follow this link for directions on how to use the Solved thread tool!
Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"