In an Address Field How do I change all UCase to 1st Letter only U

[Barb B]

In Access DB, there is a field for address I've imported from another source
and it is all upper case. I want it to be normal capitalization, i.e., after
the street number, the 1st letter of each word needs to be UCase and the rest
of the word LCase.

 

[fredg]

In Access DB, there is a field for address I've imported from another source
and it is all upper case. I want it to be normal capitalization, i.e., after
the street number, the 1st letter of each word needs to be UCase and the rest
of the word LCase.

Create an Update query:

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

This will change 123 MAIN ST. to 123 Main Street
Unfortunately it will also change 123 MCDONALD STREET to
123 Mcdonald Street.

 

[Douglas J. Steele]

<picky>
It'll change 123 MAIN ST. to 123 Main St., not 123 Main Street
</picky>

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

In Access DB, there is a field for address I've imported from another
source
and it is all upper case. I want it to be normal capitalization, i.e.,
after
the street number, the 1st letter of each word needs to be UCase and the
rest
of the word LCase.

Create an Update query:

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

This will change 123 MAIN ST. to 123 Main Street
Unfortunately it will also change 123 MCDONALD STREET to
123 Mcdonald Street.

 

[fredg]

<picky>
It'll change 123 MAIN ST. to 123 Main St., not 123 Main Street
</picky>

That's what happens when you 'hear' what you have written, rather than
'see' what you have written. <g>