Update all UpperCase to normal

  • Thread starter Thread starter Scott
  • Start date Start date
S

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
 
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.
 
Back
Top