Change Text From Uppercase to Lowercase in Access 2007

LCase will convert text to lowercase in Access 2007.

Users of the Microsoft Access 2007 database program have a number of tools for changing how text strings display. One function in particular, for example, can force text to display in all lowercase letters.

LCase

According to the Microsoft website, Access 2007 users may convert any text string or text field into lowercase letters by using the LCase function. The syntax of this function is, "LCase(string of text)."

Queries

According to the technology reference website Tech on the Net, Access 2007 users may query the Access database using the LCase function. Instead of using the command in its typical syntax, a database query would use the structure "Expr1: LCase([field name])."

Considerations

Tech on the Net notes that Access 2007 users must write scripts in Visual Basic for Applications, or VBA, to use the LCase function. Consequently, users must add the desired text as a dimension or query the database before performing the LCase conversion.

References

• Microsoft: LCase Function
• Tech on the Net: MS Access - LCase Function