Thread: Convert to Proper or Title Case in Access 2003
View Single Post
  #4  
Old April 29th, 2010, 10:44 PM posted to microsoft.public.access.queries
Marshall Barton
external usenet poster
  
Posts: 5,361
Default Convert to Proper or Title Case in Access 2003
Jeff wrote:

I am trying to convert a field that is in all CAPS to Proper Case. Ex: Field
Name is First Name, contents "ROGER". Desired way for First Name field to
show on query results is "Roger".


Check VBA Help for the StrConv function.

--
Marsh
MVP [MS Access]