[AccessD] Converting case

was just going to say isn't there a StrConv() function in Access ?

Paul


On 26 February 2014 05:58, Stephen Bond <stephen at bondsoftware.co.nz> wrote:

> http://support.microsoft.com/kb/815282
>
> Method 1 looks promising
>
>
> Stephen
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett
> Sent: Wednesday, 26 February 2014 6:00 p.m.
> To: Stephen
> Subject: [AccessD] Converting case
>
> 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
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com