Hello,

I have a problem when I want to save into database, all the data that was inserted, automatically save in lowercase format in database. I use MS Access for my database server.

For example, I have several text field and user input data not only uppercase but also lowercase. But, I do not know to make all the data that has been inputted into the database, change become lowercase?

Thank You

Access uses a version of SQL that is based on VBA, including the use of all VBA functions. So most of its functions are identical to those also used in VBScript.

In this case,
    LCASE( )
is the function you use to convert any text to lower case.

You could do it when you *retrieve* the data:
    SELECT LCASE(anyField) FROM table ...

Or you could do it when you add the data:
    INSERT INTO table (anyField) VALUES(LCASE('THIS IS UPPERCASE'))

Or you could change it in place, using UPDATE:
    UPDATE table SET anyField = LCASE( anyFIeld )