Combo Box does not display input mask

[bbeeching]

I am building an application to track my employees hand tool issue. I have set the record source for the combo box at table level. However, when I used the field list to put the control on the form, it does not display the mask. The key is a number, say..6813, the input mask adds "TB-", which gives me TB-6813 in the table. Why doesn't the combo box display TB-6813? all it will display is the number 6813. I have tried all the properties with no luck. I can put a label control on the form captioned "TB-" but I know there must be a more elegant solution. Thanks in advance for the help!

Brad Beeching

 

[Elana]

Your select statement for your combobox should say something like:

SELECT tblTools.PrimaryKey, "TB-" & [ToolID] AS [ToolNumber] FROM tblTools;

It should work just fine.