[RESOLVED] Capital letter only first string

**matrik02** · Feb 8th, 2008, 10:20 AM

How to make Capital Letter only First String ?

let say I typing "sawah sempadan", I want it store in the database like this

"Sawah Sempadan"

Code:

.Fields("Kompartment").Value = Text1.Text

**Hack** · Feb 8th, 2008, 10:32 AM

Code:

Text1.Text = StrConv(Text1.Text, vbProperCase)

**matrik02** · Feb 8th, 2008, 10:36 AM

If I typing "SAWAH SEMPADAN" or "Sawah sempadan" or "sawah sempadan". How I can store it like this "Sawah Sempadan"

**Hack** · Feb 8th, 2008, 11:06 AM

Did you try my example?

Thread: [RESOLVED] Capital letter only first string