Uppercase in lookup combo box

[jwleonard]

I would like all of the text in my database to appear in upper case. I used the > symbol in the format of all controls and in my tables also. However, on my form's lookup combos it doesn't work. When I click the dropdown it shows all selections in upper case, but after I select it turns into lower case again.

I then tried using Ucase and strConv but those don't seem to work with my combos either.

I have searched and these are all the suggestions I could find on how to do this, does anyone know another or possibly what I am doing wrong?

 

[mresann]

Base all your forms on queries, not tables. In the queries perform the StrConv functions to the fields you want formatted.

 

[jwleonard]

Thanks, is there a way to make it work without basing forms on queries? I not saying I don't want to do that, I am just trying to learn other options also. In the mean time I will give it a try.