Formatting a Colomn of a Combo Box

[kopy]

I have a 3 column combo box that has a first column that needs to be formated with leading zeros. For exapme 301 should be 000301.

Any ideas of how to do this would be great.

Thanks, Kopy.

 

[Kiwiman]

Try this

Right("000000"&yourfield,6) as your field

Take it Easy
Man with one chopstick go hungry

 

[kopy]

Thanks for replying.

A couple of questions:

The row source of the combo box is a query. Where would I put this format code? Where would I specifiy tha this is for the first column, column(0)?

 

[Kiwiman]

Open the query that underlines the combo box ( I assume there are 3 fields), and for your first column instead of having what you have put something like the below:

Column1: Right("000000" & [yourfield],6)

Take it Easy
Man with one chopstick go hungry

 

[kopy]

Great,thanks!!