G Guest Apr 27, 2005 #1 The table has text stored in a field both in UPPER Case and Proper Case. How can I format the text on a query to return Proper Case?
The table has text stored in a field both in UPPER Case and Proper Case. How can I format the text on a query to return Proper Case?
D Douglas J. Steele Apr 27, 2005 #2 SELECT StrConv([MyTextField], 3) FROM MyTable Note that this will only work if you're running the query from inside of Access. If, for example, you tried to run the query from, say, VB or ASP, it will fail.
SELECT StrConv([MyTextField], 3) FROM MyTable Note that this will only work if you're running the query from inside of Access. If, for example, you tried to run the query from, say, VB or ASP, it will fail.
