convert uppercase to lower case function?

  • Thread starter Thread starter Eric
  • Start date Start date
E

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.
 
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.
Click to expand...

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
----
 
Eric said:
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.
Click to expand...

Have a look at StrConv in Help.
 
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.
 
Back
Top