How do you change CaSe in Access

Ucase(left(firstname,1))Lcase(right(firstname,len(firstname)-1))

All my data in one column is in all CAPS. I need to change it to Title case (e.g. MATT => Matt).

here

UPDATE [tablename] Set [FieldName] = StrConv([FieldName],vbProperCase)

Here is what I tried, but it failed. Is there a way to skip 3 letter abbreveations?

<cftransaction action="begin">
<cflock scope="session" timeout="30">
<cfset recordupdate = 1>
      <cftry>
      <cfquery name="updateState" datasource="datasource">
            UPDATE tbl_Zipcodes Set City = StrConv([City],vbProperCase)
      </cfquery>
      <cfcatch type="database">
            <cfset recordupdate = 0>
      </cfcatch>
      </cftry>
      
      <cfif recordupdate IS 1>
            <cftransaction action="commit"/>
            <!--- Success --->
            SUCCESS: UPDATE COMPLETE:<br>
            <!--- Return Page --->
      <cfelse>
            <cftransaction action="rollback"/>
            <!--- Failure --->
            ERROR: UPDATE FAILED:<br>
      </cfif>
</cflock>
</cftransaction>

<cfquery name="updateState" datasource="datasource">
          UPDATE tbl_Zipcodes Set City = iif(len(CITY) > 3,StrConv([City],vbProperCase))
     </cfquery>

I continue to get an error:

 Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
 
The error occurred in D:\Inetpub\wwwroot\website.org\utl\utl_updateCities.cfm: line 5

3 : <cfset recordupdate = 1>
4 :       <cftry>
5 :       <cfquery name="updateCity" datasource="datasource">
6 :             UPDATE tbl_Zipcodes Set City = iif(len(CITY) > 3,StrConv([City],vbProperCase))      
7 :       </cfquery>

SQL          UPDATE tbl_Zipcodes Set City = iif(len(CITY) > 3,StrConv([City],vbProperCase))
DATASOURCE         singlesscene
VENDORERRORCODE         -3010
SQLSTATE         07002

sorry, needs the 'else'

<cfquery name="updateState" datasource="datasource">
          UPDATE tbl_Zipcodes Set City = iif(len(CITY) > 3,StrConv([City],vbProperCase),[City])
     </cfquery>

Nope, stll getting errors, here is everything:

CODE:
<cftransaction action="begin">
<cflock scope="session" timeout="30">
<cfset recordupdate = 1>
      <cftry>
      <cfquery name="updateCities" datasource="datasource">
            UPDATE tbl_Zipcodes Set City = iif(len(CITY) > 3,StrConv([City],vbProperCase),[City])
      </cfquery>
      <cfcatch type="SHOWERROR">
            <cfset recordupdate = 0>
      </cfcatch>
      </cftry>
      
      <cfif recordupdate IS 1>
            <cftransaction action="commit"/>
            <!--- Success --->
            SUCCESS: UPDATE COMPLETE:<br>
            <!--- Return Page --->
      <cfelse>
            <cftransaction action="rollback"/>
            <!--- Failure --->
            ERROR: UPDATE FAILED:<br>
      </cfif>
</cflock>
</cftransaction>

ERROR:
ODBC Error Code = 07001 (Wrong number of parameters)

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

Hint: The cause of this error is usually that your query contains a reference to a field which does not exist. You should verify that the fields included in your query exist and that you have specified their names correctly.

SQL = "UPDATE tbl_Zipcodes Set City = iif(len(CITY) > 3,StrConv([City],vbProperCase),[City])"

Data Source = "Datasource"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (8:2) to (8:56) in the template file F:\website\utl\utl_updateCities.cfm.

BINGO!

Thank you so much !!!

Here is the source code for everyone:

NOTE: Replace CAPITALS with your values

<cftransaction action="begin">
<cflock scope="session" timeout="30">
<cfset recordupdate = 1>
      <cftry>
      <cfquery name="NAME" datasource="DATASOURCE">
            Update TABLE Set COLUMN= iif(len(COLUMN) > 3,StrConv([COLUMN],3),[COLUMN])
      </cfquery>
      <cfcatch type="database">
            <cfset recordupdate = 0>
      </cfcatch>
      </cftry>
      
      <cfif recordupdate IS 1>
            <cftransaction action="commit"/>
            <!--- Success --->
            Success: Update Complete:<br>
            <!--- Return Page --->
      <cfelse>
            <cftransaction action="rollback"/>
            <!--- Failure --->
            Error: Update Failed:<br>
      </cfif>
</cflock>
</cftransaction>