Change from Capitals

[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.

 

[Guest]

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

ChrisJ
Omaha

 

[Joseph Meehan]

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.

I find a guillotine used once usually takes care of such problems.

Sorry I can't really answer your question, I have always been able to
control my users so I never had to work with that correction. I can tell
you that I believe some people here have the answer and should reply. Good
Luck

 

[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.

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]

 

[Ian]

Thanks very much for your help,

Ian.

-----Original Message-----

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.

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]
.