Update all UpperCase to normal

[Scott]

Hello all,

I want to put code in the ON DOUBLE CLICK of a field on a form so that when
I double click the field it should update the field so that every word in
this field should be lower case EXCEPT for the first character of the word;
doe's anyone know how to do that. ?

Thanks

Scott

 

[Cheryl Fischer]

The StrConv() function should work for this task:

You could use the following code behind your event:

me!MyField = StrConv(me!MyField, 3)


You could also use an Update Query to update all of the data in your field
to Proper Case.