Undefined Function in Access 2007

I am trying to convert strings in Access to Proper Case.  I'm calling the function I created "ProperCase" in a query and I continually get the "undefined function" error.  I have clicked on the Tools References and don't find any "missing" references at all.  I can't compile the code because the "compile" line is dimmed.  The code has worked in previous versions of access, so I figured I'm just not calling it up right.  The code is entered as a module and named "Propercase".  I am simply calling it in an update query as Propercase([FirstName]), when I get the error.

Any help would be appreciated.

Option Explicit           ' Require variables to be declared before being used.
Option Compare Database   ' Use database order for string comparisons.
 
Function ProperCase(strToChange As String) As String
    ' Converts string to Proper case
    On Error Resume Next
    ProperCase = StrConv(strToChange, vbProperCase)
End Function

Select allOpen in new window