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