I need to find a way of changing an all Caps address to an address that has a cap in the first letter only.


For example:
convert 44 HARRISON RD to 44 Harrison Rd



This might also be accomplished by converting to an Access database.

Thank you for any help in coding this

tshirttom