Changing first letter of text to Upper Case

[mikehoot]

I need to create an update qry to change a text string form lower case, to beginning with an Upper case letter. e.g

Change the brown cow
to The brown cow

Can anybody help? I would like to use query builder.

B-)

 

[Maquis]

Check out the strConv(string,option) function in Access help. I believe option 1 will convert to mixed case.

txtName = strconv(txtName,1)

Maq B-)
<insert witty signature here>

 

[THoey]

I think my friend Maq has given you more than you wanted. That will upper case every first letter of each word in the string. Try the following:

txtName = (STRCONV(LEFT(txtName, 1), 1) & _
RIGHT (txtname, (LEN(txtname - 1)))

Hope that helps...



Terry M. Hoey