Changing from capital to small letters

Hello I have a table in which there is a field LNAME in which last names
have been entered with capitol letters. For example: SMITH.
I want to change them to small letters except the first one, so it will
become: Smith
Is it possible?

Thank you
Dimitris

try:

StrConv(strPassed, vbProperCase)



Ed Warren

"Dimitris" wrote in message
...
Hello I have a table in which there is a field LNAME in which last names
have been entered with capitol letters. For example: SMITH.
I want to change them to small letters except the first one, so it will
become: Smith
Is it possible?

Thank you
Dimitris

Dimitris,
Just an minor addition to Ed's correct response. It's the best you can
do for automating the solution to your poblem
Be aware though, that names like...
MCCARTHY
would come out as
Mccarthy
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Dimitris" wrote in message
...
Hello I have a table in which there is a field LNAME in which last names
have been entered with capitol letters. For example: SMITH.
I want to change them to small letters except the first one, so it will
become: Smith
Is it possible?

Thank you
Dimitris

Thank you for your answers.
I just can't figure where to write it.
I made a querie and wrote it at the SQL view but wasn;t accepted.
Please tell me where to write it. What steps should I do?
Thank You
Dimitris


"Al Camp" wrote in message
...
Dimitris,
Just an minor addition to Ed's correct response. It's the best you can
do for automating the solution to your poblem
Be aware though, that names like...
MCCARTHY
would come out as
Mccarthy
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Dimitris" wrote in message
...
Hello I have a table in which there is a field LNAME in which last names
have been entered with capitol letters. For example: SMITH.
I want to change them to small letters except the first one, so it will
become: Smith
Is it possible?

Thank you
Dimitris

Open a new query window in design view.
Add the table with the field of interest
add the field LNAME
in the next box over add the following
LnameProperCase: StrConv([LNAME], vbProperCase)
run the query to see the results.

If after you see what the code does to the fields, and you like it, and you
want to change the stored data.
Then
change the query type to update
copy the code: StrConv([LNAME], vbProperCase) into the updateto box under
the LNAME field, run the query.

Ed Warren

"Dimitris" wrote in message
...
Thank you for your answers.
I just can't figure where to write it.
I made a querie and wrote it at the SQL view but wasn;t accepted.
Please tell me where to write it. What steps should I do?
Thank You
Dimitris


"Al Camp" wrote in message
...
Dimitris,
Just an minor addition to Ed's correct response. It's the best you can
do for automating the solution to your poblem
Be aware though, that names like...
MCCARTHY
would come out as
Mccarthy
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Dimitris" wrote in message
...
Hello I have a table in which there is a field LNAME in which last names
have been entered with capitol letters. For example: SMITH.
I want to change them to small letters except the first one, so it will
become: Smith
Is it possible?

Thank you
Dimitris

Ed,
As far as I know, queris don't recognize the visual basic constants, so you
have to specify the actual value.

Therefore StrConv([LNAME], vbProperCase) should be StrConv([LName],3)



"Ed Warren" wrote in message
...
Open a new query window in design view.
Add the table with the field of interest
add the field LNAME
in the next box over add the following
LnameProperCase: StrConv([LNAME], vbProperCase)
run the query to see the results.

If after you see what the code does to the fields, and you like it, and
you want to change the stored data.
Then
change the query type to update
copy the code: StrConv([LNAME], vbProperCase) into the updateto box under
the LNAME field, run the query.

Ed Warren

"Dimitris" wrote in message
...
Thank you for your answers.
I just can't figure where to write it.
I made a querie and wrote it at the SQL view but wasn;t accepted.
Please tell me where to write it. What steps should I do?
Thank You
Dimitris


"Al Camp" wrote in message
...
Dimitris,
Just an minor addition to Ed's correct response. It's the best you
can do for automating the solution to your poblem
Be aware though, that names like...
MCCARTHY
would come out as
Mccarthy
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Dimitris" wrote in message
...
Hello I have a table in which there is a field LNAME in which last
names have been entered with capitol letters. For example: SMITH.
I want to change them to small letters except the first one, so it will
become: Smith
Is it possible?

Thank you
Dimitris

Yes you are correct replace the constant vbProperCase with the number 3

Thanks,

Ed Warren

"John Spencer" wrote in message
...
Ed,
As far as I know, queris don't recognize the visual basic constants, so
you have to specify the actual value.

Therefore StrConv([LNAME], vbProperCase) should be StrConv([LName],3)



"Ed Warren" wrote in message
...
Open a new query window in design view.
Add the table with the field of interest
add the field LNAME
in the next box over add the following
LnameProperCase: StrConv([LNAME], vbProperCase)
run the query to see the results.

If after you see what the code does to the fields, and you like it, and
you want to change the stored data.
Then
change the query type to update
copy the code: StrConv([LNAME], vbProperCase) into the updateto box
under the LNAME field, run the query.

Ed Warren

"Dimitris" wrote in message
...
Thank you for your answers.
I just can't figure where to write it.
I made a querie and wrote it at the SQL view but wasn;t accepted.
Please tell me where to write it. What steps should I do?
Thank You
Dimitris


"Al Camp" wrote in message
...
Dimitris,
Just an minor addition to Ed's correct response. It's the best you
can do for automating the solution to your poblem
Be aware though, that names like...
MCCARTHY
would come out as
Mccarthy
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Dimitris" wrote in message
...
Hello I have a table in which there is a field LNAME in which last
names have been entered with capitol letters. For example: SMITH.
I want to change them to small letters except the first one, so it
will become: Smith
Is it possible?

Thank you
Dimitris

Place this function in a module:
Function Proper(Pr)
Proper = StrConv(Pr, vbProperCase)
End Function

Then you can put this:
LName=Proper([LNAME])
in a query field.

Originally Posted by Dimitris

Thank you for your answers.
I just can't figure where to write it.
I made a querie and wrote it at the SQL view but wasn;t accepted.
Please tell me where to write it. What steps should I do?
Thank You
Dimitris


"Al Camp" wrote in message
...
Dimitris,
Just an minor addition to Ed's correct response. It's the best you can
do for automating the solution to your poblem
Be aware though, that names like...
MCCARTHY
would come out as
Mccarthy
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Dimitris" wrote in message
...
Hello I have a table in which there is a field LNAME in which last names
have been entered with capitol letters. For example: SMITH.
I want to change them to small letters except the first one, so it will
become: Smith
Is it possible?

Thank you
Dimitris

Thank you all,
It worked fine, I am very happy about this.
Only one issue which has to do with the Greek grammar and it won't make
sense if I explain it. I just have to do this. After using the code you told
me I have to change the last letter of some names. To stay at my first
example "SMITH" became "Smith" but how can I change now the "h" at the end
of "Smith" with another letter. I need to change ALL the letters "h" at THE
END of names only.
So in my mind it's something like: Wherever a name ends with "h" change it
with "c" for example. Well in Greek we have 2 possibilities for a letter so
I need to change it to the other one, that is why I need this.
Thank you in advance
Dimitris


"Ed Warren" wrote in message
...
Yes you are correct replace the constant vbProperCase with the number 3

Thanks,

Ed Warren

"John Spencer" wrote in message
...
Ed,
As far as I know, queris don't recognize the visual basic constants, so
you have to specify the actual value.

Therefore StrConv([LNAME], vbProperCase) should be StrConv([LName],3)



"Ed Warren" wrote in message
...
Open a new query window in design view.
Add the table with the field of interest
add the field LNAME
in the next box over add the following
LnameProperCase: StrConv([LNAME], vbProperCase)
run the query to see the results.

If after you see what the code does to the fields, and you like it, and
you want to change the stored data.
Then
change the query type to update
copy the code: StrConv([LNAME], vbProperCase) into the updateto box
under the LNAME field, run the query.

Ed Warren

"Dimitris" wrote in message
...
Thank you for your answers.
I just can't figure where to write it.
I made a querie and wrote it at the SQL view but wasn;t accepted.
Please tell me where to write it. What steps should I do?
Thank You
Dimitris


"Al Camp" wrote in message
...
Dimitris,
Just an minor addition to Ed's correct response. It's the best you
can do for automating the solution to your poblem
Be aware though, that names like...
MCCARTHY
would come out as
Mccarthy
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Dimitris" wrote in message
...
Hello I have a table in which there is a field LNAME in which last
names have been entered with capitol letters. For example: SMITH.
I want to change them to small letters except the first one, so it
will become: Smith
Is it possible?

Thank you
Dimitris

So in my mind it's something like: Wherever a name ends with "h" change it with "c"
for example. Well in Greek we have 2 possibilities for a letter so I need to change
it to the other one, that is why I need this.
Thank you in advance
Dimitris

IIf(Right([TestString], 1) = "h", Left([TestString], Len([TestString]) - 1) & "c",
[TestString])

Tom Lake