ComboBoxData, change Capital to non-Capital 3

[HydraNL]

Hi,

How do I change the text in the ComboBox from Capital to non-capital?

The ComboBox is filled on Form_Load()

Do Until rs.EOF
Combo1.AddItem rs!TEST
rs.MoveNext
Loop

Greetings J. Radjesh Klauke (Netherlands)

 

[zemp]

Look into the LCase() and UCase() functions.

...
Combo1.AddItem LCase(rs!TEST)
...

zemp

 

[Sumitdev]

You could use the LCase function

Do Until rs.EOF
   Combo1.AddItem lcase(rs!TEST)
   rs.MoveNext
Loop

 

[HydraNL]

Thanks guys. Works fine.

One question remains. How do I make onlythe first letter Capital and the rest LCase?

Greetings J. Radjesh Klauke (Netherlands)

 

[tsdragon]

Combo1.AddItem UCase(Left(rs!TEST, 1)) & LCase(Right(rs!TEXT, Len(rs!TEXT)-1))

Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.

 

[HarleyQuinn]

Tracy,

An easier way to convert to Proper case would be to use:

Combo1.AddItem StrConv(rs!TEST, vbProperCase)

Cheers

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HydraNL]

The code of HarleyQuinn works fast. But both of you deserve a shiny. Thank you both for the effort.

Greetings J. Radjesh Klauke (Netherlands)

 

[HarleyQuinn]

You're welcome, thanks for the star

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[tsdragon]

HydraNL: Thanks for the star!

HarleyQuinn: I'd completely forgotten about strConv! Thanks for reminding me!


Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.