Change from Capitals

I

Ian

I have a db that has names in a table. I have multiple
users entering data via a Palm db system that I import
from. Some users insist on entering Surname as full
capitals. Once I've imported the data into Access how can
I change the format of the already entered data into
capitalised first letter and lower case for the reaminder?

Thanks for your help,
Ian.
 
C

ChrisJ

Try something like this in a query:
ProperName: StrConv(StrConv([tblMain]![LastName],2),3)

ChrisJ
Omaha
 
J

John Vinson

I have a db that has names in a table. I have multiple
users entering data via a Palm db system that I import
from. Some users insist on entering Surname as full
capitals. Once I've imported the data into Access how can
I change the format of the already entered data into
capitalised first letter and lower case for the reaminder?

Thanks for your help,
Ian.
Click to expand...

The StrConv() function will do this for you; create an Update query,
updating Surname to

StrConv([Surname], 3)

It would be best to use a criterion such as

WHERE StrComp([Surname], UCase([Surname]), 0) = 0

to only convert the all caps names. Note that names with different
capitalization (MacArthur, van Steen, etc.) will be converted to
Macarthur and Van Steen and may need to be manually corrected.

John W. Vinson[MVP]
 
Top