• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

How can all Upper Case letters to changed to mixed case in Access 2007?

The data coming into the Access 2007 database is in all CAPS. I need to translate all Upper case letters to mixed case. I am currently using:

 Mid(UpperCaseString,1,1) & Mid(LCase(UpperCaseString,2,254)) to get the 1st letter in CAPs and the following letters in lower case.

 Is there an easier  way to have all upper case letters changed to 1st letter upper case and all other letters lower case (for all words separated by a space) in UpperCaseString?

thanks.
0
newbie46
Asked:
newbie46
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
use strconv()

fieldName=strconv([FieldName],3)
0
 
newbie46Author Commented:
THANK YOU!!
0
 
Rey Obrero (Capricorn1)Commented:
you can run an update query

update table
set [fieldName]=strconv([fieldname],3)
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now