[AccessD] Converting case

Thanks, I'll give it a try tomorrow.

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Stephen Bond
> Sent: 25 Feb 2014 9:59 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Converting case
> 
> 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.acc
> db
> 
> 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