Update Query for changing uppercase to lowercase not working

[Phyllis622]

I have a table containing a field for FirstName and another for LastName and both of these fields are currently all Uppercase text. I would like to change these two fields to Propercase (ie. change JOHN DOE to John Doe). I created a query to update my table and included the ID, FirstName, and LastName fields. I then typed in StrConv([FirstName],3) in the Critera under the FirstName field, but it's not working. I am fairly new to this and just can't seem to figure out what I'm doing wrong, any ideas?

[ssanfu]

but it's not working

What is not working? Any error messages?
What is the SQL of the query?

[Phyllis622]

No error messages, but when I run the query, nothing happens. The data is still in all uppercase. I didn't type an SQL statement just the StrConv() in the Criteria field

[orange]

Be careful

There may be some weird ones
Ali Vant Goor
Jean Guy Tremblay
Steven desJardins
Ursula K. Le Guin

[Phyllis622]

I just figured it out. Wow, how stupid, I just needed to click on the Update on the ribbon and then place the StrConv() expression in the Update row not the criteria row. Works now. It's been a long day, I should probably take a break. Thank you for your help!