Initial capitalization

[Bill H.]

Is there some code floating around that can take a street address as input,
and output the same but with all the words Initial Caps?

I've got a database of addresses and some folks are failing on the SHIFT key
function.

Thanks.

 

[fredg]

Is there some code floating around that can take a street address as input,
and output the same but with all the words Initial Caps?

I've got a database of addresses and some folks are failing on the SHIFT key
function.

Thanks.

Codt the Address control's AfterUpdate event:
Me![Address] = StrConv([Address],3)

Note: this will incorrectly capitalize words that should have more
than one capital letter, i.e. MacDonald Street, as well as incorrectly
capitalize words that should not be capitalized, i.e. van Houten
Street.