G Guest May 24, 2006 #1 In a query expression, how do I change only the initial character in a text field to lower case? Thanks, group.
In a query expression, how do I change only the initial character in a text field to lower case? Thanks, group.
G Guest May 24, 2006 #2 If your source field is called MyText, your expression would be: CorrectedTex: LCase(Left$(MyText,1)) & Right$(MyText,Len(MyText)-1) HTH, Barry
If your source field is called MyText, your expression would be: CorrectedTex: LCase(Left$(MyText,1)) & Right$(MyText,Len(MyText)-1) HTH, Barry
