convert uppercase to lower case function?

[Eric]

Does anyone knows if there exists a function that can
convert uppercase strings to lowercase?
I'm popultaing column named names from another database
but the problems is that both the first name and last
name are all in uppercase. it would be nice to gave a
function that leaves the first character of the name in
uppercase and the rest in lowercase, the same for the
last name.

Thanks in advance.

 

[Nick Coe \(UK\)]

In Eric typed:

Does anyone knows if there exists a function that can
convert uppercase strings to lowercase?
I'm popultaing column named names from another database
but the problems is that both the first name and last
name are all in uppercase. it would be nice to gave a
function that leaves the first character of the name in
uppercase and the rest in lowercase, the same for the
last name.

Thanks in advance.

Look up StrConv() in Access Help, vbProperCase is the
constant you'll need IIRC.

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----

 

[Brian]

Does anyone knows if there exists a function that can
convert uppercase strings to lowercase?
I'm popultaing column named names from another database
but the problems is that both the first name and last
name are all in uppercase. it would be nice to gave a
function that leaves the first character of the name in
uppercase and the rest in lowercase, the same for the
last name.

Thanks in advance.

Have a look at StrConv in Help.

 

[Douglas J. Steele]

LCase(MyTextValue) will convert everything to lower case.
StrConv(MyTextValue, vbProperCase) or StrConv(MyTextValue, 3) will convert
the first letter of every word in string to uppercase, with the remaining
letters in lower case. Note, though, that this wouldn't be correct for names
like MacDonald or van der Graaf.