[AccessD] Converting case

LCase will lowercase all of the letters.  UCase will UPPERCASE all of the
letters. What you want is ProperCase.  Google or search the archives for
that.

David Gibson






















On Tue, Feb 25, 2014 at 10:49 PM, Kathryn Bassett <kathryn at bassett.net>wrote:

> On to another. Googling gets me some answers for Excel, but not Access.
>
> https://www.dropbox.com/s/c5cg7uji1kkhr0i/ConnerBishopHistoriesPlay.accdb
>
> In the Histories table, I converted the Country field using Find/Replace.
> But I don't relish the time required to do that with StateProvince, County,
> and Town. Is there a quick way to change those to first letter upper case,
> rest lower case?
>
> For instance NOVA SCOTIA to Nova Scotia, SAINT JEAN to Saint Jean, CLARKE
> COUNTY to Clarke County?
>
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>