[RESOLVED] Capital letter only first string

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

---

Code:

---

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

---

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

Did you try my example?