Combo box to only display first letter of selection

[spectraflame]

I would like to be able to create a combo box that displays only the first character of the text in the field from a specific table.

Currently my combo box is looking at a specific column in a table and showing me the full text. I have tried the LEFT("Classification",1) but I cannot seem to get that to work.

Is there a better way?

Thanks,
Matthew

 

[Norie]

Sorry maybe I'm being thick.

But the only purpose of this combobox is to abbreviate the classification.

It does nothing else. It isn't used anywhere else on the form to look something up.

 

[spectraflame]

Sorry,

The value selected in the combo box will be store in the main data table. Eventually I will be using this value to hopfully determine labor and inventory charge numbers.

Since we only have two classification codes, (C) Capital and (M) Maintenance; I think that I may just add another field to the table for the abbreviation. I will still us a query for my combo box to reference just in case I need to add or remove a value.

Thanks again,
Matthew