Convert to proper case

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a an address field in my form. I would like to convert the first
letters of any letter to upper case e.g., if I enter 123 pleasantville ave
apt# 11
It should be converted to 123 Pleasantville Ave Apt# 11

How do I do that?
 
Please do a search. How to do this in a Name field is asked very
frequently. the answer here would be pretty much the same.

The short answer is that you would need to do it manually - there are too
many exceptions to do it automatically.

What about:

123 McMillin Street?
444 NW 18th Street? (Nw?)
12 de los Santos Avenue

Etc.
 
Check Access HELP for the StrConv() function, using vbProperCase.

As Rick points out, this will force capitalization of every word. Rather
that doing it all manually, though, you could:
* make a backup copy
* use the StrConv() function
* apply USB (using someone's brain) to review and spot those few you'd
need to uncapitalize

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top