proper case

A

Allen Browne

Use the AfterUpdate event procedure of the Address text box.
Include this line of code:
Me.Address = StrConv(Me.Address, vbProperCase)

I'm not sure this will work well though. Some street names will be wrong,
e.g. McDonald.
 
B

Bob Barrows [MVP]

AShi said:
how to convert uppercase Address field to propercase
Click to expand...

Instead of asking your question again, how about letting us know why the
original answers we gave were deficient?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UpperCase to ProperCase and Back again 3
how to convert uppercase to proper name using update query 4
Another case sensitive query 2
Excel - stop automatically changing mixture of uppercase and lowercase to propercase 2
How to determine if field is all uppercase? 2
upper case lower case 0
Way to query both ProperCase & Upper Case 4
Finding the proper style field and the numbered paragraph value within the style 0

Top