Format Combobox

[Hdata]

Thanks in advance. I'm using a lookup table to populated a combo box on my form. I use a provided list of input strings (hundreds) in my combo box and the list is provided in all caps. How can I convert these provided words (strings) to first cap from either the quarry level or form level.

Best regards

 

[jdraw]

see this description and samples