Capitalize address

[jptpjs via AccessMonster.com]

I have data that has all capital letters in the address.
I created an update query for the lastname, firstname, city. Works great.
How do you start where the first letter begins like in an address.

34778 MAIN STREET
Need to change tgo 34778 Main Street

Thanks

Pete

 

[fredg]

I have data that has all capital letters in the address.
I created an update query for the lastname, firstname, city. Works great.
How do you start where the first letter begins like in an address.

34778 MAIN STREET
Need to change tgo 34778 Main Street

Thanks

Pete

Update YourTable Set YourTable.AddressField =
StrConv([AddressField],3)

Note. This will not properly capitalize names which should have more
than one capital, i.e. 1234 O'Connor Street will become 1234 O'connor
Street., nor names that should not be capitalized, i.e. 4567 van der
Meer Avenue will become 4567 Van Der Meer Avenue.

 

[jptpjs via AccessMonster.com]

How do I change the existing records?
Will this work in an update query?
I believe I had poor results before.

Thanks

I have data that has all capital letters in the address.
I created an update query for the lastname, firstname, city. Works great.

[quoted text clipped - 6 lines]

Pete

Update YourTable Set YourTable.AddressField =
StrConv([AddressField],3)

Note. This will not properly capitalize names which should have more
than one capital, i.e. 1234 O'Connor Street will become 1234 O'connor
Street., nor names that should not be capitalized, i.e. 4567 van der
Meer Avenue will become 4567 Van Der Meer Avenue.

 

[fredg]

How do I change the existing records?
Will this work in an update query?
I believe I had poor results before.

Thanks

I have data that has all capital letters in the address.
I created an update query for the lastname, firstname, city. Works great.

[quoted text clipped - 6 lines]

Pete

Update YourTable Set YourTable.AddressField =
StrConv([AddressField],3)

Note. This will not properly capitalize names which should have more
than one capital, i.e. 1234 O'Connor Street will become 1234 O'connor
Street., nor names that should not be capitalized, i.e. 4567 van der
Meer Avenue will become 4567 Van Der Meer Avenue.

You change existing record by running the Update query I gave you.
Copy and paste it into a new query's SQL window.
Substitute your actual field and table names.
If you are unsure of what you are doing, back up your existing table
first.

After you run the query successfully, examine the results. If you spot
any names that are incorrectly capitalized, you can manually correct
them.