Bob Gajewski
rbgajewski at roadrunner.com
Wed Feb 26 00:26:56 CST 2014
Temp = StrConv(Temp, vbProperCase) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stephen Bond Sent: Wednesday, February 26, 2014 00:59 AM 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.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