Coverting Upper Case to Lower Case

T

TJAC

Do you know of a fairly simple way for a user to export lowercase and
uppercase textual data from an Access database into mixed case data in a Word
document or Excel spreadsheet. For example if someone's name in the database
is all upper case then can it be exported to the first letter as upper and
the remaining text as lower.

Thanks,
 
O

Ofer

You can use the strconv function

In a query
Select strconv(FieldName,3) As NewField From TableName
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing lower to upper case issue 1
upper case lower case 0
Lower-Case Characters 2
Differences between lower case and upper case 4
Change text from lower case to upper case in Access 2007 1
Lower case date 4
Change all upper case letters to lower case 1
Formatting upper or lower case text 3

Top