[AccessD] Converting case

Kathryn Bassett kathryn at bassett.net
Tue Feb 25 22:49:10 CST 2014


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   






More information about the AccessD mailing list