Change case of text data.

[Paul Yowhan]

I get data from a third party and the e-mail address is
all uppercase. I have issue whith that data when passing
to another database. Anyone oknow of an access function
that can convert upper to lowwer case of a test field?

 

[Liz]

You can change this by using the LCase function in a
query.
In a new query add the following to the field line on the
field that needs to be changed: LCase ([field name])
You will also have to name your field something other than
what it is actually called or you will get a circular
reference. Your field line will look like this:
Field Name1: LCase ([field name])
You can have a Make Table query or Select
query...depending on how you are sending to the other db.
You can also read up on LCase in Help.
Good Luck!

 

[John Vinson]

I get data from a third party and the e-mail address is
all uppercase. I have issue whith that data when passing
to another database. Anyone oknow of an access function
that can convert upper to lowwer case of a test field?

You can run an Update query updating the field to

LCase([fieldname])

This will convert "331 ELM ST." to "331 elm st."

If you would prefer Proper case - "331 Elm St." - there is a different
function: update the field to

StrConv([fieldname], 3)