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.



--
Rick B



"JOM" <(E-Mail Removed)> wrote in message
news:15693A4F-B6A4-4AFD-869D-(E-Mail Removed)...
>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?

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


"JOM" <(E-Mail Removed)> wrote in message
news:15693A4F-B6A4-4AFD-869D-(E-Mail Removed)...
>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?