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)