If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Display leading zeros in combo box with numeric field

I have a numeric field that I must use for this application. Customer driven. I can display the leading zeros in other forms by formatting with 00000. However, in this combo box that is pulling the information directly from the table, I set the format to 00000 and it does not display the leading zeros.

I realized I wasn't totally clear in my question. It will display the leading zeros after I have selected my item from the drop down box. It is the drop down box that displays the numbers just as they are entered in the table. The field is in sql and it is a int field. I am now wondering if I can trick the drop down box by pulling my information from a query versus directly from the table? I might try that.