DatabaseLessons.com

'Serving the Microsoft® Access
Community since 1997'

News/Blog
Tables
Queries
Forms
Reports
Modules
Miscellaneous
Subscribe
Free Samples
Videos
Services
Links
About Us

 

 

Proper Case - capitalizing just the first character

You just imported a bunch of data from the client and notice that it is all in upper case. You want mixed case so that "RICHARD KILLEY" becomes "Richard Killey".

Create an update query and put the field(s) in the grid. In the update cells put commands similar to this:

    StrConv([firstname],3)

In VBA code you can use the vbProperCase constant in place of the 3, but I could not get it to work in the query, so I substituted the numeric equivalent.

Other constants are vbUpperCase (1) and vbLowerCase (2).

NOTE: All the VBA code segments on the Database Lessons site assume that you have DAO references active. If you are not sure what this means, and you are using Microsoft Access 2000 or higher, click here.

(article continues after sponsor spot)



Happy Coding

 
Note: This web site dedicated to MS Access database users is an independent publication of Richard W. Killey and is not affiliated with, nor has it been authorized, sponsored, or otherwise approved by Microsoft® Corporation.
 

 

© 2006, 2007, 2008 Richard W. Killey. All Rights Reserved. - Privacy Policy