Capitalize column in listbox generated from query

[CantDo]

Hi. I have a listbox on a form generated from a query that is working properly. However, despite the fact that the table field has an input mask forcing all caps, the query returns first cap only. Unfortunately, I am also forcing all caps in the data entry section so I get mixed results in the list box depending on how the data was entered.

Anyway, what I want to achieve is consistency -- all caps everywhere. As stated, I have an input mask on both the table field and on the input form field. However, the list box still shows initial cap only. I tried to put an input mask on the query field, but it doesn't seem to work. Anyone have any ideas?

FYI, the input mask I'm using is >LCCCCCCCCCCCCCCCCCCCCCCCCC

Thanks in advance for any advice.

 

[PHV]

Why not using the UCase function in your query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[CantDo]

Thanks anyway, PHV, but I just had to put > int he format field of the query column and that seemed to do the trick. Thanks again.