Displaying form fields

[sakthivels]

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.

[RuralGuy]

Have you read this link yet?

[sakthivels]

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.

[RuralGuy]

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

[sakthivels]

Respected RuralGuy,

It finally works. Thanks for the reply.

[RuralGuy]

Excellent! Glad to hear you got it sorted.