By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,222 Members | 1,610 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,222 IT Pros & Developers. It's quick & easy.

Setting ListBox character to UPPER case.

P: 13
Hello.. is there any by chance to set the listbox into upper case?

Thanks once again.
Jul 14 '09 #1
Share this Question
Share on Google+
4 Replies

Expert 100+
P: 1,287
There is a UCase() function you can use as you add items to the list box. If the source data for the listbox is SQL, then you could loop through the items in the listbox and set them to upper case one at a time after loading. If you have a lot of items, it's probably preferable to have the listbox property Visible = No while you do so, then make it visible when finished.
Jul 14 '09 #2

Expert 2.5K+
P: 3,532
I think the only way to do this is to set the formatting to the RowSource of the Listbox, as the Listbox control itself has no Format Property. If the Listbox is based on a table, you'll need to create a query based on that table, then create calculated fields for the fields to be displayed, then base the Listbox on these fields as opposed to the original fields. The calculated fields would look something like this:

UCNameField: UCase([NameField])

So, when creating the Listbox, you would use the query as the RowSource and select UCNameField as the field to include rather than NameField.

Welcome to Bytes!

Linq ;0)>
Jul 14 '09 #3

P: 13
Hey. hey.
Thanks alot once again. i the with your help i solve the problem.

i used this code on my query UCNameField: UCase([NameField]) and hey.. its working. and thanks for welcoming me..

Thanks for the suggestion guys..
Jul 14 '09 #4

Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Jul 14 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.