Apr 13, 2005 #1 mdr227 Programmer Joined Nov 17, 2000 Messages 114 Location US Can someone tell me how to convert a field of text that is all upper case to mixed case (first letter of each word capitalized)?
Can someone tell me how to convert a field of text that is all upper case to mixed case (first letter of each word capitalized)?
Apr 13, 2005 #2 PHV MIS Joined Nov 8, 2002 Messages 53,708 Location FR Take a look at the StrConv function with 2nd argument = vbProperCase Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244 Upvote 0 Downvote
Take a look at the StrConv function with 2nd argument = vbProperCase Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
Apr 19, 2005 #3 CharlieT302 Instructor Joined Mar 17, 2005 Messages 406 Location US There is an easy fix that can be done directly from table design. In the "Input Mask" property type the following code: >a<aaaaaaaaaaaa Where the total number of "a" codes must match the value indicated in the "Field Size" property. Upvote 0 Downvote
There is an easy fix that can be done directly from table design. In the "Input Mask" property type the following code: >a<aaaaaaaaaaaa Where the total number of "a" codes must match the value indicated in the "Field Size" property.
Apr 19, 2005 #4 Golom Programmer Joined Sep 1, 2003 Messages 5,595 Location CA PHV You're right of course ... but I've found that StrConv has a bug in it. StrConv ("convert to proper case", vbProperCase ) blows up but StrConv ("convert to proper case", 3 ) works even though vbProperCase = 3. Upvote 0 Downvote
PHV You're right of course ... but I've found that StrConv has a bug in it. StrConv ("convert to proper case", vbProperCase ) blows up but StrConv ("convert to proper case", 3 ) works even though vbProperCase = 3.
Apr 20, 2005 #5 PHV MIS Joined Nov 8, 2002 Messages 53,708 Location FR Golom, I guess your StrConv call was issued in a query and thus no VB constant is recognized. Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244 Upvote 0 Downvote
Golom, I guess your StrConv call was issued in a query and thus no VB constant is recognized. Hope This Helps, PH. Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244