Convert to proper case

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

 

[Rick B]

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.

 

[Jeff Boyce]

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