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

how to convert uppercase to proper name using update query 4
UpperCase to ProperCase and Back again 3
Change Case 1
How to determine if field is all uppercase? 2
Excel - stop automatically changing mixture of uppercase and lowercase to propercase 2
Way to query both ProperCase & Upper Case 4
Access Propercase 2
Another case sensitive query 2

Top