the Manx Man's MS Access Pages

Proper Case - Capitalizing Just the First Character (008)

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 like this:

         StrConv([firstname],3)

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

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