[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.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