Initial capitalization

  • Thread starter Thread starter Bill H.
  • Start date Start date
B

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.
 
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.
Click to expand...

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.
 
Back
Top