M MBaronet Dec 1, 2007 #1 Can text case be changed in a field. For example, the entire field is in upper case. I need to change it to title case.
Can text case be changed in a field. For example, the entire field is in upper case. I need to change it to title case.
J John W. Vinson Dec 2, 2007 #2 Can text case be changed in a field. For example, the entire field is in upper case. I need to change it to title case. Click to expand... Run an Update query updating the field to StrConv([fieldname], 3) That Will Convert It To Proper Case (Like This). 2 will CONVERT IT TO ALL CAPS; 1 will convert it to lower case. John W. Vinson [MVP]
Can text case be changed in a field. For example, the entire field is in upper case. I need to change it to title case. Click to expand... Run an Update query updating the field to StrConv([fieldname], 3) That Will Convert It To Proper Case (Like This). 2 will CONVERT IT TO ALL CAPS; 1 will convert it to lower case. John W. Vinson [MVP]
